Tom Lane wrote: > 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. Oh right, there are 2 sections about those expressions... Never noticed that there was "9.16. Subquery Expressions" and "9.17. Row and Array Comparisons" listing the same expressions. (Apparently there are 2 more sections before it in your documentation) -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World // ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster