Re: ANY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alban Hertroys <alban(at)magproductions(dot)nl>
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-06 18:55:33
Message-ID: 390.1189104933@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

  • Re: ANY at 2007-09-06 15:56:30 from Alban Hertroys

Responses

  • Re: ANY at 2007-09-11 12:43:38 from Alban Hertroys

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-06 19:09:27 Re: a provocative question?
Previous Message Webb Sprague 2007-09-06 18:43:43 Re: Do AGGREGATES consistently use sort order?