Re: Seamless replacement to MySQL's GROUP_CONCAT function... - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Seamless replacement to MySQL's GROUP_CONCAT function...
Date
Msg-id 20130805170442.GA27382@eldon.alvh.no-ip.org
Whole thread Raw
In response to Seamless replacement to MySQL's GROUP_CONCAT function...  ("immersive.excel@gmail.com" <immersive.excel@gmail.com>)
Responses Re: Seamless replacement to MySQL's GROUP_CONCAT function...  (Richard Broersma <richard.broersma@gmail.com>)
Re: Seamless replacement to MySQL's GROUP_CONCAT function...  ("immersive.excel@gmail.com" <immersive.excel@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [tsearch2] Problem with case sensitivity (or with creating own dictionary)
Next
From: Don Parris
Date:
Subject: Connecting Multiple LibreOffice Base Users to a Remote Postgres Database