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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
