Re: Concatenate strings using GROUP BY

am  09.02.2006, um 10:35:03 +0100 mailte Philippe Lang folgendes:
> id    fk    str
> ---------------
> 1     1     a
> 2     1     b
> 3     2     c
> 
> Is there a pure SQL way of contactenating str values into a single string,
> and get instead:
> 
> id    fk    str
> ---------------
> 1     1     a/b
> 2     12    c
> 
> I was thinking of something like:
> 
> SELECT id, fk, CONCAT(str || '/')
> FROM FOO
> GROUP BY fk
> 
> Do we have to use PL/PGSQL for that?

Yes, you need a new aggregate function.
http://www.postgresql.org/docs/8.0/interactive/xaggr.html


HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===