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

Re: Review: listagg aggregate

From: Scott Bailey <artacus(at)comcast(dot)net>
To:
Cc: "pgsql-hackers(at)postgresql(dot)org Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Review: listagg aggregate
Date: 2010-01-25 05:29:38
Message-ID: 4B5D2C42.2070404@comcast.net (view raw or flat)
Thread:
Lists: pgsql-hackers
>> I don't think. When we have function, with same parameters, same
>> behave like some Oracle function, then I am strongly prefer Oracle
>> name. I don't see any benefit from different name. It can only confuse
>> developers and add the trable to people who porting applications.
> 
> Meh. If the name is terrible, we don't have to use it, and it's easy enough to create an alias in SQL for those who need it.

The corresponding function in Oracle is called wm_concat. In MySQL its 
called group_concat. I don't believe DB2 or SQL Server have built in 
equivalents. The Oracle name isn't really an option ("wm' stands for 
workspace manager)

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.

Scott

In response to

Responses

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2010-01-25 06:47:40
Subject: Re: Streaming Replication on win32
Previous:From: KaiGai KoheiDate: 2010-01-25 05:29:12
Subject: Re: [BUG?] strange behavior in ALTER TABLE ... RENAME TO on inherited columns

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