sum the text of a text field - Mailing list pgsql-general

From Sim Zacks
Subject sum the text of a text field
Date
Msg-id ge9guq$2u6f$1@news.hub.org
Whole thread Raw
Responses Re: sum the text of a text field  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: sum the text of a text field  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
-----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-----

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: psql screen size
Next
From: "A. Kretschmer"
Date:
Subject: Re: sum the text of a text field