On Tue, Jan 26, 2010 at 2:14 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > 2010/1/25 Robert Haas <robertmh...@gmail.com>: >> On Mon, Jan 25, 2010 at 2:27 PM, David E. Wheeler <da...@kineticode.com> >> wrote: >>> On Jan 25, 2010, at 2:09 AM, Peter Eisentraut wrote: >>>> xmlagg -> concatenates values to form xml datum >>>> array_agg -> concatenates values to form array datum >>>> ??? -> concatenates values to form string datum >>> >>> concat_agg(). >> >> I like that one... > > why is concat_agg better than listagg ?
Because it doesn't make lists. Honestly, I don't love concat_agg() either - why should something need to have agg in the name just because it's an aggregate? I think the most descriptive name would be something like concatenate_with_separator(), but that's kind of long. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers