| From: | Todd Vierling <tv(at)pobox(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgreSQL(dot)org |
| Subject: | Re: [BUGS] (null) != (null) ? |
| Date: | 1999-10-26 14:41:52 |
| Message-ID: | Pine.NEB.4.10.9910261040460.26623-100000@server.int.duh.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, 26 Oct 1999, Todd Vierling wrote:
: : NULL = NULL does not yield TRUE, it yields NULL. For that matter,
: : NULL != NULL does not yield FALSE --- it yields NULL. This is a
: : basic consequence of the semantics of NULL.
: It seems _extremely_ counter-intuitive, especially in cases where both
: fields are in fact the same type.
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".
--
-- Todd Vierling (tv(at)pobox(dot)com)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Todd Vierling | 1999-10-26 15:50:10 | Re: [BUGS] (null) != (null) ? |
| Previous Message | Todd Vierling | 1999-10-26 14:08:01 | Re: [BUGS] (null) != (null) ? |