Re: RFC: array_agg() per SQL:200n - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: RFC: array_agg() per SQL:200n
Date
Msg-id 1201558303.10057.620.camel@dogma.ljc.laika.com
Whole thread Raw
In response to RFC: array_agg() per SQL:200n  (Neil Conway <neilc@samurai.com>)
Responses Re: RFC: array_agg() per SQL:200n  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
On Sun, 2008-01-27 at 22:11 -0800, Neil Conway wrote:
> p. 564 discusses the required behavior. The result of array_agg() is an
> array with one element per input value, sorted according to the optional
> ORDER BY clause. NULL input values are included in the array, and the
> result for an empty group is NULL, not an empty array. Note that per
> page 66, I'd expect array values in the input to array_agg() not to be
> flattened.

Should there be an inverse operator (a SRF, in this case) that returns a
set from an array?

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: "Roberts, Jon"
Date:
Subject: Re: autonomous transactions
Next
From: Jeff Davis
Date:
Subject: Re: CLUSTER and synchronized scans and pg_dump et al