Re: Who knows this SELECT in PostgreSQL

On Samstag 06 Juni 2009 Milen A. Radev wrote:
> CREATE AGGREGATE public.array_agg(ANYELEMENT) (
>     SFUNC = ARRAY_APPEND,
>     STYPE = ANYARRAY,
>     INITCOND = '{}'
> );
> SELECT
>     ARRAY_TO_STRING(public.ARRAY_AGG(b.messageblk),'') AS the_message

Wow, very cryptic. Would never have found that, thanks a lot!

> If you can wait for or want to test version 8.4 (which is in Beta
> right now and would be released relatively soon) you can skip the
> creation of the aggregate.

Need it now, but good to know 8.4 helps here :-)

mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660 / 415 65 31 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4