On Mon, Nov 26, 2007 at 03:51:37AM +1100, Brendan Jurd wrote:
> Hi all,
>
> 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
Hi all,
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.
Until reading this, I didn't even realise that empty arrays were
possible, since ARRAY[] causes a syntax error. I played around with
the array input syntax