On Jan 29, 2009, at 5:50 PM, Tom Lane wrote:
I don't think we want it to come true. If we treat IS DISTINCT FROM
as a weirdly-named operator then we have to provide an implementation
for every datatype (oh, and another one for IS NOT DISTINCT FROM).
The PITA factor is enormous. Much better to
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(),
David E. Wheeler da...@kineticode.com writes:
Seems to me that IS DISTINCT FROM is just another operator, like =,
Wishful thinking...
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On Thu, Jan 29, 2009 at 08:12:12PM -0500, Tom Lane wrote:
David E. Wheeler da...@kineticode.com writes:
Seems to me that IS DISTINCT FROM is just another operator, like
=,
Wishful thinking...
What would it take to make this wish come true?
Cheers,
David.
--
David Fetter
David Fetter da...@fetter.org writes:
On Thu, Jan 29, 2009 at 08:12:12PM -0500, Tom Lane wrote:
David E. Wheeler da...@kineticode.com writes:
Seems to me that IS DISTINCT FROM is just another operator, like =,
Wishful thinking...
What would it take to make this wish come true?
I don't