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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Todd Vierling <tv(at)pobox(dot)com>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] (null) != (null) ?
Date: 1999-10-26 16:23:53
Message-ID: 23230.940955033@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Todd Vierling <tv(at)pobox(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 1999-10-26 16:48:05 Re: [BUGS] (null) != (null) ?
Previous Message Tom Lane 1999-10-26 15:52:46 Re: [BUGS] (null) != (null) ?