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