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

From Pavel Stehule
Subject Re: Review: listagg aggregate
Date
Msg-id 162867791001250234jff7765du9ab7ddb3f3d8f53a@mail.gmail.com
Whole thread Raw
In response to Re: Review: listagg aggregate  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Review: listagg aggregate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2010/1/25 Peter Eisentraut <peter_e@gmx.net>:
> On sön, 2010-01-24 at 21:29 -0800, Scott Bailey wrote:
>> I think listagg or string_agg would be the most appropriate names. Oh
>> and before Oracle had wm_concat, Tom Kyte wrote a function called
>> stragg that was pretty popular.
>
> Well,
>
> xmlagg -> concatenates values to form xml datum
> array_agg -> concatenates values to form array datum
> ??? -> concatenates values to form string datum
>
> So it's pretty clear that listagg does not fit into this scheme.

when you define list as text domain, then this the name is correct.

searching "list sql string" on google. You can see, so "list" is usually used.

Regards
Pavel

>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Review: listagg aggregate
Next
From: Craig Ringer
Date:
Subject: Re: pg_listener entries deleted under heavy NOTIFY load only on Windows