Re: sum the text of a text field

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 specific field in the result set.

Do you want to concat all rows to a string?

,----[ Column to string with delimiter, David Fetter ]
| test=*# select * from w;
| t
| --------
| test
| foo
| bar
| foobar
| (4 rows)
|
| test=*# SELECT array_to_string(ARRAY(SELECT t FROM w), ',');
| array_to_string
| ---------------------
| test,foo,bar,foobar
| (1 row)
`----

HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net