Should IS DISTINCT FROM work with ANY()?

From: David E(dot) Wheeler <david(at)kineticode(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Should IS DISTINCT FROM work with ANY()?
Date: 2009-01-29 21:08:51
Message-ID: 5A910B13-5EA0-4F4B-9CCD-14A725290260@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2009-01-29 21:36:47 Re: mingw check hung
Previous Message Andrew Chernow 2009-01-29 20:11:41 PQinitSSL broken in some use cases