=?UTF-8?B?54mH5pysIOS6mOelkO+8iOODpuODi+ODvOOCr+ODk+OCuOODp+ODs++8iQ==?= <katamoto_kosuke(at)uniquevision(dot)co(dot)jp> writes:
> select
> 1 <> all(array[2,1,1])
> ->false --bug
What makes you think that's a bug? There are array elements that
the "1" fails to be not equal to.
> select
> 1 <> any(array[2,1,1])
> ->true --bug
There is an array element that the "1" is not equal to.
I see no bug here either.
regards, tom lane