Re: Seamless replacement to MySQL's GROUP_CONCAT function...

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: "immersive(dot)excel(at)gmail(dot)com" <immersive(dot)excel(at)gmail(dot)com>, x3v0-pgsql(at)yahoo(dot)com, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, David Fetter <david(at)fetter(dot)org>
Subject: Re: Seamless replacement to MySQL's GROUP_CONCAT function...
Date: 2013-08-05 17:15:08
Message-ID: CABvLTWEZyie9+zZZ9+xJNgaPsNLOL=OfOn2KROSrbryyQY2QEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

For posterity that finalized function could be posted here:

http://okbob.blogspot.com/2009/08/mysql-functions-for-postgresql.html

There's already a GROUP_CONCAT, listed there, but I guess this one was
lacking in some way.

On Mon, Aug 5, 2013 at 10:04 AM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>wrote:

> immersive(dot)excel(at)gmail(dot)com escribió:
>
> > Note: I found some close-but-no cigar aggregates shared online, but
> > they would not accept integer arguments, nor would they handle the
> > optionally furnished delimiter. People would suggesting casting the
> > argument to the pseudo-GROUP_CONCAT. Again: Rewrite perhaps hundreds
> > of queries?<br>
>
> I don't think you need all the variations; you should be able to make
> them all work with a single set of functions, taking ANYELEMENT instead
> of text/int8/int4 etc.
>
>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
Regards,
Richard Broersma Jr.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message immersive.excel@gmail.com 2013-08-05 17:55:59 Re: Seamless replacement to MySQL's GROUP_CONCAT function...
Previous Message Don Parris 2013-08-05 17:12:36 Connecting Multiple LibreOffice Base Users to a Remote Postgres Database