Re: [GENERAL] Empty arrays with ARRAY[] - Mailing list pgsql-hackers

On Nov 26, 2007 3:58 AM, Martijn van Oosterhout <kleptog@svana.org> wrote:
> On Mon, Nov 26, 2007 at 03:51:37AM +1100, Brendan Jurd wrote:
> > I noticed in the 8.3 release notes that ARRAY(SELECT ...) now returns
> > an empty array if there are no rows returned by the subquery.
>
> This has come up before, Tom had an idea about how to fix it:
>
> http://groups.google.com/group/pgsql.general/browse_thread/thread/911791e145a17daa/6b035035aeaac399
> http://www.mail-archive.com/pgsql-general@postgresql.org/msg90681.html

[moving thread to -hackers]

Thanks for the link Martijn.  I'd be interested in taking a swing at
this if nobody else has laid claim.  Since that thread died back in
January, I'm guessing it's wide open.

Regards,
BJ