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



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to