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.
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 |