Martijn van Oosterhout wrote:
On Thu, Jan 01, 2004 at 11:53:29PM +0100, Baldur Norddahl wrote:
Ok, but since this can be quite annoying and unexpected, could we get an
operator that does not use tristate logic but simply compares? Maybe == which
seems to be free :-)
So X==Y is true if X and Y
Quoting Guy Fraser [EMAIL PROTECTED]:
There already is an operator, and it is the ANSI SQL operator IS. Just
because IS does not use puctuation characters does not mean it is not
an operator.
IS is not an operator in postgresql, at least not in the same sense that =
is an operator. You can
Hi all;
Here is a brief guide to NULL's and Referential Integrity:
NULL is a special SQL value meaning 'unknown.' Well, it is a little more
complicated and NULL can mean value does not exist. Therefore X = NULL is
NULL becuase we don't know if the NULL is equal to X. So:
NULL does not equal
Baldur Norddahl wrote:
Quoting Martijn van Oosterhout [EMAIL PROTECTED]:
...
You could create a new operator, but that means you'll have difficulty
moving it to any database that doesn't have that operator (which is most of
them).
Any commercial database vendor would be happy to make such
Tom Lane wrote:
Not sure that it's fair to characterize this as a property of the
relational model. It is a property of the SQL standard.
Yes indeed - I fell into the classic Relational model and SQL are not
the same thing trap !
Mark
---(end of
Quoting Martijn van Oosterhout [EMAIL PROTECTED]:
Annoying, not really. It's actually extremely useful. It's useful having a
value which is never equal to anything else, not even itself. If you use it
to represent unknown it will work for you. If you try to use it for
anything else, it will