Alban Hertroys <alban@xxxxxxxxxxxxxxxxx> 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
