Re: - Mailing list pgsql-bugs

From Yury Bokhoncovich
Subject Re:
Date
Msg-id Pine.LNX.4.33.0203112024130.5154-100000@panda.center-f1.ru
Whole thread Raw
In response to ...  (Bhuvan A <bhuvansql@yahoo.com>)
List pgsql-bugs
Hello!

On Mon, 11 Mar 2002, Bhuvan A wrote:

[skip]
> > If you compare a NULL with anything you don't get a true value whether
> > you're comparing with =, !=, <, >, etc...  That's how it's defined to
> > behave.
>
> where did you get this definition of behaviour!? is it applicable only to
> postgres or ..?  its quite strange yaar!

it's standard SQL:
true and true gives true
true and false gives false
null and true gives null
null and false gives null

RTFM! Quick check on MySQL and MSSQL gives the same results.
AFAIK Interbase and Oracle behaves similarly.
So theory is confirmed by practice.
It is very amazing to listen about contrary thing, could you please tell
where you saw this?

--
WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
Phone: +7 (3832) 106228, ext.140, E-mail: byg@center-f1.ru.
Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #611: configure script produces incorrect results under IRIX
Next
From: Peter Eisentraut
Date:
Subject: Re: