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