Horton

Re: [BUGS] (null) != (null) ?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Todd Vierling <tv@pobox.com>
Cc: pgsql-bugs@postgreSQL.org
Date: 1999-10-26T16:23:53Z
Lists: pgsql-bugs 
Todd Vierling <tv@pobox.com> writes:
> Although I did find a SQL92 document on the web in the amount of time this
> took to copy back to me, and I see the clause about NULL <comp op>
> <anything> being unknown.  Which, I imagine, means "implementation
> dependent".

No.  It means unknown, ie, NULL.  SQL's predicates are three-valued.

			regards, tom lane