Alban Hertroys <alban(at)magproductions(dot)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