Alban Hertroys <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings