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