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

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/group/pgsql.general/browse_thread/thread/911791e145a17daa/6b035035aeaac399
http://www.mail-archive.com/pgsql-general@postgresql.org/msg90681.html

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy