Re: Review: listagg aggregate - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Review: listagg aggregate
Date
Msg-id 15473.1264527373@sss.pgh.pa.us
Whole thread Raw
In response to Re: Review: listagg aggregate  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Review: listagg aggregate  ("David E. Wheeler" <david@kineticode.com>)
Re: Review: listagg aggregate  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
"David E. Wheeler" <david@kineticode.com> writes:
> Because it's an aggregate that cocatenates values. It's not an  
> aggregate that lists things. I also like concat_agg better than  
> string_agg because it's not limited to acting on strings.

But what it *produces* is a string.  For comparison, the
SQL-standard-specified array_agg produces arrays, but what it
acts on isn't an array.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ECPGset_var
Next
From: "Kevin Grittner"
Date:
Subject: Re: testing cvs HEAD - HS/SR - missing file