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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
