Should IS DISTINCT FROM work with ANY()? - Mailing list pgsql-hackers

From David E. Wheeler
Subject Should IS DISTINCT FROM work with ANY()?
Date
Msg-id 5A910B13-5EA0-4F4B-9CCD-14A725290260@kineticode.com
Whole thread Raw
Responses Re: Should IS DISTINCT FROM work with ANY()?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Howdy,

Shouldn't this work?
  postgres=# SELECT 'foo' IS DISTINCT FROM ANY(ARRAY['foo']);  ERROR:  syntax error at or near "ANY"  LINE 1: SELECT
'foo'IS DISTINCT FROM ANY(ARRAY['foo']);
 

Seems to me that IS DISTINCT FROM is just another operator, like =,  
and so it should work with ANUY(), no?

Tested on 8.2 and 8.3.

Thanks,

David




pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: PQinitSSL broken in some use cases
Next
From: Magnus Hagander
Date:
Subject: Re: mingw check hung