sum the text of a text field

Поиск
Список
Период
Сортировка
От Sim Zacks
Тема sum the text of a text field
Дата
Msg-id ge9guq$2u6f$1@news.hub.org
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: psql screen size
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: sum the text of a text field