Re: looking for alternative to MySQL's GROUP_CONCAT function

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: <x3v0-pgsql(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: looking for alternative to MySQL's GROUP_CONCAT function
Date: 2005-10-21 19:41:41
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE92E766@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2005-10-21 19:51:50 Handling of pad characters (was RE: Oracle buys Innobase )
Previous Message Apu Islam 2005-10-21 19:31:45 Re: scheduled backup