| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | Charles Holleran <scorpdaddy(at)hotmail(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Library |
| Date: | 2010-09-28 10:39:03 |
| Message-ID: | AANLkTikvPK8phX0_YnVVzPh4CXvGOHXX_09R9uAyW-9c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 28 September 2010 11:21, Charles Holleran <scorpdaddy(at)hotmail(dot)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 not quite 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 and see the notes on building your own aggregator. But this one for example has been done soo many times already. I was thinking that there might be a library where we are sharing our .sql files of nice functions, triggers, etc, ... Anyone know of 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2010-09-28 10:40:18 | Re: Library |
| Previous Message | Charles Holleran | 2010-09-28 10:21:07 | Library |