Re: ANY

Alban Hertroys <alban@magproductions.nl> writes:
> Richard Huxton wrote:
>> AFAIK there are two variants of ANY()
>> 1. sets
>> 2. arrays
>>
>> So you should be able to do:
>> ... WHERE x = ANY( ARRAY[a, b, c] )

> But then the documentation isn't entirely correct. It suggests that it
> works similar to IN, but it doesn't.

The subquery variants (section 9.19) do work the same.  There is nothing
on the other page (9.20) making such a comparison.

            regards, tom lane