-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 It was easier then I thought. I built a custom function because I wanted each field value to be on its own line. create or replace function textsum(text,text) returns text as $$ select coalesce($1,'') || case when $1 is null then '' else case when $2 is not null then E'\n' else '' end end || coalesce($2,''); $$ language sql; create aggregate sum(text) ( sfunc=textsum, stype=text ); Sim Sim Zacks wrote: > Is there any way (aside from creating a new aggregate type) to sum the > text in a text field. I would like to group on a query and concatenate > all the values of a specific field in the result set. > > This is a common practice and currently I find myself writing functions > to iterate the data to basically build my own text sum function. > > I'm going to look into building my own aggregate type, but if there is > something out there that works it will make life simpler. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkkITc0ACgkQjDX6szCBa+qcawCg2N9Xt9gnX0tvhaYE7iDJE5Lt pwYAoIRipArzjODonqzr00peTP933yPY =DNJz -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
