Re: [HACKERS] Should IS DISTINCT FROM work with ANY()?

2009-01-30 Thread David E. Wheeler
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

[HACKERS] Should IS DISTINCT FROM work with ANY()?

2009-01-29 Thread David E . Wheeler
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(),

Re: [HACKERS] Should IS DISTINCT FROM work with ANY()?

2009-01-29 Thread Tom Lane
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:

Re: [HACKERS] Should IS DISTINCT FROM work with ANY()?

2009-01-29 Thread David Fetter
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

Re: [HACKERS] Should IS DISTINCT FROM work with ANY()?

2009-01-29 Thread Tom Lane
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