Re: Subselects returning array and ANY...

[Josh Berkus <josh(at)agliodbs(dot)com>]

Dawid,

> But you are right, though!  I just need to leave off the subselect! 
> Thanks! SELECT h.* FROM haystack h JOIN needles ON straw = ANY (straws);
>
> (not exactly what I was looking for, but it works ;))

Yeah, the problem with your first query is that it's returning a rowset of 
arrays, not a single array.  This means that ANY() doesn't know exactly 
what to do with it.

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco