aggregate functions - Mailing list pgsql-general

From Holger Klawitter
Subject aggregate functions
Date
Msg-id 394DD69E.FB2EC3E@klawitter.de
Whole thread Raw
List pgsql-general
Hi there,

is there any easy way to add the string concatenation operator
as a collating operator? I would like to do something like:

id val
------
1  aa
1  bb
2  cc
2  dd
2  ee

select id,join(val,',') from table group by id

id join
-----------
1  aa,bb
2  cc,dd,ee

and it would be nice not having to revert to DBI :-)

Regards,
Mit freundlichem Gruß,
    Holger Klawitter
--
Holger Klawitter                                    +49 (0)251 484 0637
holger@klawitter.de                            http://www.klawitter.de/


pgsql-general by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: RE: PostgreSQL on NT: new cygwin?
Next
From: "Andrea Aime"
Date:
Subject: Weird error on NT