David Fetter wrote:
> Folks,
>
> Shouldn't this work and produce a "true?"
>
> SELECT NULL IS NOT DISTINCT FROM ANY(ARRAY['a',NULL]);
> ERROR: syntax error at or near "ANY"
> LINE 1: SELECT NULL IS NOT DISTINCT FROM ANY(ARRAY['a',NULL]);
It should, but probably depends on whether "IS NOT DISTINCT" should be
considered an "operator".
http://www.postgresql.org/docs/8.4/static/functions-comparisons.html#AEN16561
Got caught by the same thing a couple of days ago.
--
Richard Huxton
Archonet Ltd