Search Postgresql Archives

Re: ANY

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux