View Single Post

   
  #1 (permalink)  
Old 04-15-2008, 11:34 PM
Brendan Jurd
 
Posts: n/a
Default Re: [GENERAL] Empty arrays with ARRAY[]

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...035035aeaac399
> http://www.mail-archive.com/pgsql-ge.../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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote