Thread: [BUGS]
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
片本 亘祐(ユニークビジョン) <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