Re: [GENERAL] Empty arrays with ARRAY[]

2007-11-25 Thread Martijn van Oosterhout
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

[GENERAL] Empty arrays with ARRAY[]

2007-11-25 Thread Brendan Jurd
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