Re: How to test to VARCHAR2's for equality EFFICIENTLY ?

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Fri, 21 Nov 2003 17:08:21 -0500
Message-ID: <Y_adnQspaNB6ESOiRVn-vA@comcast.com>

xho -- not sure who you're addressing your comments to, but you hit the basic issue -- we're trying to translate 3-value (true/false/null) logic into 2-value logic

refer to my other post for a complete example on why the proposed logic does not work as johng expected

• mcs

<ctcgag_at_hotmail.com> wrote in message
news:20031121161114.889$3v_at_newsreader.com...
| johng_at_mm.nospam.com wrote:
| > Inline comment:
| > "mcstock" <mcstockspamplug_at_spamdamenquery.com> wrote:
| >
| > >close....
| > >
| > >'x' != 'x' is false, returns 0 -- ok
| > >'x' != 'y' is true, return 1 -- ok
| > >null != null is null, returns 1 -- ok
| > >'x' != null is also null, returns 1 -- not ok
| > >
| >
| > Sorry but
| > 'x' != null ( By the way that is a bad comparison operator when using
| > NULL, it should be 'x' is not NULL) is TRUE and should return a 1 -
| > Nothing is equal to null, so x is not equal to null either..

|

| Don't you think that he knows what he needs his function to return
| better than you do? If he just wanted to accept the normal behavior of
| the three-valued logic operations, we wouldn't be having this thread,
| would we?

|

| Xho

|

| --
| -------------------- http://NewsReader.Com/ --------------------
| Usenet Newsgroup Service New Rate! $9.95/Month 50GB
Received on Fri Nov 21 2003 - 16:08:21 CST