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

From Tom Lane
Subject Re: Review: listagg aggregate
Date
Msg-id 19808.1264427830@sss.pgh.pa.us
Whole thread Raw
In response to Re: Review: listagg aggregate  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Review: listagg aggregate  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Review: listagg aggregate  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2010/1/25 Peter Eisentraut <peter_e@gmx.net>:
>> 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.

IOW, if you define away the problem then there's no problem?

I agree that "list" is a terrible choice of name here.  "string_agg"
seemed reasonable and in keeping with the standardized "array_agg".
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: pg_listener entries deleted under heavy NOTIFY load only on Windows
Next
From: Greg Stark
Date:
Subject: Fwd: Questions about connection clean-up and "invalid page header"