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 <klep...@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.
signature.asc
Description: Digital signature
