Thread: [BUGS]

[BUGS]

From
片本 亘祐(ユニークビジョン)
Date:
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



Re: [BUGS]

From
Tom Lane
Date:
片本 亘祐(ユニークビジョン) <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