Re: [GENERAL] sum the text of a text field

2008-10-29 Thread Sim Zacks
-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

Re: [GENERAL] sum the text of a text field

2008-10-29 Thread A. Kretschmer
am Wed, dem 29.10.2008, um 13:20:59 +0200 mailte Sim Zacks folgendes: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > 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 specifi