Postgres Pro
Downloads
Home   >   mailing lists

Re: ordered aggregates using WITHIN GROUP (was Re: can somebody execute this query on Oracle 11.2g and send result?) - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: ordered aggregates using WITHIN GROUP (was Re: can somebody execute this query on Oracle 11.2g and send result?)
Date
Msg-id 36e682921001290909s7c80d07ataaf65c9464f7c48d@mail.gmail.com
Whole thread Raw
In response to Re: ordered aggregates using WITHIN GROUP (was Re: can somebody execute this query on Oracle 11.2g and send result?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ordered aggregates using WITHIN GROUP (was Re: can somebody execute this query on Oracle 11.2g and send result?)  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List pgsql-hackers
Tree view
On Fri, Jan 29, 2010 at 11:57 AM, Tom Lane <tgl@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]

--
Jonah H. Harris

pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: Hot Standby: Relation-specific deferred conflict resolution
Next
From: "Jonah H. Harris"
Date:
Subject: Re: ordered aggregates using WITHIN GROUP (was Re: can somebody execute this query on Oracle 11.2g and send result?)