Re: SQL Query - Mailing list pgsql-general

From A. Kretschmer
Subject Re: SQL Query
Date
Msg-id 20071205120406.GG24799@a-kretschmer.de
Whole thread Raw
In response to Re: SQL Query  (David Fetter <david@fetter.org>)
List pgsql-general
am  Wed, dem 05.12.2007, um  3:46:26 -0800 mailte David Fetter folgendes:
> Use the array_accum aggregate from the docs as follows:
>
> SELECT x, array_to_string(array_accum(y),':')
> FROM your_table
> GROUP BY x;

Yes, no noubt a better solution as my new aggregat...


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: SQL Query
Next
From: Alvaro Herrera
Date:
Subject: Re: Moving pgstat.stat and pgstat.tmp