Skip site navigation (1) Skip section navigation (2)

Re: Review: listagg aggregate

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Scott Bailey <artacus(at)comcast(dot)net>, "pgsql-hackers(at)postgresql(dot)org Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Review: listagg aggregate
Date: 2010-01-25 10:34:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
2010/1/25 Peter Eisentraut <peter_e(at)gmx(dot)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.


> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


pgsql-hackers by date

Next:From: Craig RingerDate: 2010-01-25 10:42:06
Subject: Re: pg_listener entries deleted under heavy NOTIFY load only on Windows
Previous:From: Herouth MaozDate: 2010-01-25 10:09:33
Subject: Re: Questions about connection clean-up and "invalid page header"

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group