| From: | Alban Hertroys <alban(at)magproductions(dot)nl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ANY |
| Date: | 2007-09-11 12:43:38 |
| Message-ID: | 46E68D7A.2050306@magproductions.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> 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.
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(at)magproductions(dot)nl
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 //
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phoenix Kiula | 2007-09-11 12:55:47 | Re: Hardware recommendation: which is best |
| Previous Message | Franz.Rasper | 2007-09-11 12:42:24 | Re: Hardware recommendation: which is best |