Re: [GENERAL] Seamless replacement to MySQL's GROUP_CONCAT function...

[immersive.ex...@gmail.com]

I believe his VARIADIC might cover the optional delimiter use, but he suggests using an array aggregation function instead -which does not return a string list, so you would still have to rework the original queries. Now you could write a GROUP_CONCAT aggregate that uses a final function to convert the array to a string list -but correct me if I'm wrong, I believe the way I am concatenating as I go uses less resources (an array of, say, 5000 elements versus a string...) But while I am testing use of the ANYELEMENT, I will see if VARIADIC can simplify things a tad more... ======================== On 08/05/2013 01:15 PM, Richard Broersma wrote: 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 <alvhe...@2ndquadrant.com> wrote: immersive.ex...@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.