No title
PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
5.3.1-14ubuntu2) 5.3.1 20160413, 64-bit
select
1 <> all(array[1,1,1])
->false --no problem
select
1 <> all(array[2,1,1])
->false --bug
select
1 <> any(array[2,3,4])
-> true --no problem
select
1 <> any(array[2,1,1])
->true --bug
=?UTF-8?B?54mH5pysIOS6mOelkO+8iOODpuODi+ODvOOCr+ODk+OCuOODp+ODs++8iQ==?= <katamoto_kosuke@uniquevision.co.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs