On Fri, Jan 29, 2010 at 12:09 PM, Jonah H. Harris <jonah.har...@gmail.com>wrote:
> On Fri, Jan 29, 2010 at 11:57 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> I find it doubtful that it's actually necessary in Oracle's version >> of listagg ... >> > > Eh? > > > http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/functions087.htm > > Defines: > > *LISTAGG* (measure_expr [, 'delimiter_expr']) > *WITHIN GROUP* (order_by_clause) [*OVER* query_partition_clause] > > > SQL Server's listagg is similar to the PG implementation. It seems Oracle thinks people would prefer to order the list and for that reason, made their listagg a rank function type. Having done quite a bit of work generating delimited lists/arrays based on ordering in PG, I generally agree that it's what I would generally want. -- Jonah H. Harris