On 28 September 2010 11:21, Charles Holleran <scorpdaddy@hotmail.com> wrote:
> A nice string concatenation aggregator in pg would be nice. Is there one in 8.4? I've been using array_agg but it's
notquite the same. Nor xml_agg.
>
> In any case I was wondering if our community has an on-line repository of shared code? I mean you can read the litt
andsee the notes on building your own aggregator. But this one for example has been done soo many times already. I was
thinkingthat there might be a library where we are sharing our .sql files of nice functions, triggers, etc, ... Anyone
knowof such?
People place a lot of snippets on the wiki, but not exactly an
organised set of functions:
http://wiki.postgresql.org/wiki/Category:Library_Snippets
The PostGresql eXtension Network (PGXN) is still in development:
http://www.pgxn.org
But as for a built-in string aggregate, that's only available from 9.0
onward. string_agg:
http://www.postgresql.org/docs/9.0/static/functions-aggregate.html
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
