Re: Question about the ANY operator

On Mon, Dec 21, 2009 at 02:46:59AM -0800, Mike Christensen wrote:
> I'm having trouble figuring out the ANY operator..  Basically I want to
> return rows that match any of the given IDs:
>
> select Name from Users where UserId = ANY
> ARRAY['948aeda5-ffff-41bd-af4e-71d1c740db76',
> '5ee315ea-7ef6-4fa5-809a-dc9931a01ed1']::uuid[];

The syntax is '= ANY(foo)', you're missing the parenthesis.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.