Re: [GENERAL] Empty arrays with ARRAY[]

On Nov 26, 2007 3:58 AM, Martijn van Oosterhout <kleptog(at)svana(dot)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(at)postgresql(dot)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