Richard Huxton wrote:
> Alban Hertroys wrote:
>>
>> SELECT * FROM gdp WHERE NULL IS NOT ANY(y1970, y1971, y1972);
> 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.
> Of course, where x is NULL, I don't think that'll help you (x = NULL
> returns NULL). Oh, and you couldn't have nulls in arrays before 8.2 iirc.
Well, as ANY allows the use of an operator, I figured you could use IS
NULL with it.
--
Alban Hertroys
alban@magproductions.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 //