Thread

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

Tom Lane <tgl@sss.pgh.pa.us> — 1999-10-26T16:23:53Z

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