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

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Seamless replacement to MySQL's GROUP_CONCAT function...
Дата
Msg-id CABvLTWEZyie9+zZZ9+xJNgaPsNLOL=OfOn2KROSrbryyQY2QEg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Seamless replacement to MySQL's GROUP_CONCAT function...  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Seamless replacement to MySQL's GROUP_CONCAT function...
Список 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@2ndquadrant.com> wrote:
immersive.excel@gmail.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Regards,
Richard Broersma Jr.

В списке pgsql-general по дате отправления: