Re: looking for alternative to MySQL's GROUP_CONCAT function - Mailing list pgsql-general

From Magnus Hagander
Subject Re: looking for alternative to MySQL's GROUP_CONCAT function
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E766@algol.sollentuna.se
Whole thread Raw
In response to looking for alternative to MySQL's GROUP_CONCAT function  (<x3v0-pgsql@yahoo.com>)
List pgsql-general
> Hi all,
>
> I'm looking into PostgreSQL. Coming from a MySQL background,
> I have made heavy use of its very useful GROUP_CONCAT
> function. You can read about the function
> here:
>
> http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
>
> Is there a PostgreSQL alternative to GROUP_CONCAT?

Check the user comments at
http://www.postgresql.org/docs/8.0/interactive/sql-createaggregate.html.
Sounds like what you're looking for.

//Magnus

pgsql-general by date:

Previous
From: Apu Islam
Date:
Subject: Re: scheduled backup
Next
From: "Guy Rouillier"
Date:
Subject: Handling of pad characters (was RE: Oracle buys Innobase )