pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
(no subject) 2+ messages / 2 participants [nested] [flat]
* (no subject) @ 2017-02-09 02:28 片本 亘祐（ユニークビジョン） <katamoto_kosuke@uniquevision.co.jp> 2017-02-09 02:37 ` Re: Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: 片本 亘祐（ユニークビジョン） @ 2017-02-09 02:28 UTC (permalink / raw) To: pgsql-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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 2017-02-09 02:28 (no subject) 片本 亘祐（ユニークビジョン） <katamoto_kosuke@uniquevision.co.jp> @ 2017-02-09 02:37 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2017-02-09 02:37 UTC (permalink / raw) To: 片本 亘祐（ユニークビジョン） <katamoto_kosuke@uniquevision.co.jp>; +Cc: pgsql-bugs =?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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-02-09 02:37 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2017-02-09 02:28 片本 亘祐（ユニークビジョン） <katamoto_kosuke@uniquevision.co.jp> 2017-02-09 02:37 ` Re: Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox