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