Postgres Pro
Downloads
Home   >   mailing lists

BUG #13289: ANY() function produces a paradox - Mailing list pgsql-bugs

From udtelco@gmail.com
Subject BUG #13289: ANY() function produces a paradox
Date
Msg-id 20150514171253.2687.47260@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13289: ANY() function produces a paradox  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #13289: ANY() function produces a paradox  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: BUG #13289: ANY() function produces a paradox  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13289
Logged by:          Anton
Email address:      udtelco@gmail.com
PostgreSQL version: 9.3.2
Operating system:   Solaris 11.2
Description:

select ('2' != any('{2,3}')) , ('2' = any('{2,3}'))

When != (or <>) operator is applied to any() , results are wrong. Thereby,
you have a situation where x = y AND x != y both evaluating as true.

pgsql-bugs by date:

Previous
From: David Gould
Date:
Subject: Re: BUG #13286: Core dumped during pg_terminate_backend call.
Next
From: Tom Lane
Date:
Subject: Re: BUG #13289: ANY() function produces a paradox