-----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. 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 iEYEARECAAYFAkkIRxsACgkQjDX6szCBa+pClACgi1gV9FsE4Hj5bdOueHENwq2l lo0An09lAf160qz/nYMnb0LLCF6VU7Qs =pkwu -----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
