Skip site navigation (1) Skip section navigation (2)

Re: comparing rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: comparing rows
Date: 2000-08-03 13:55:35
Message-ID: 7364.965310935@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Magnus Hagander <mha(at)sollentuna(dot)net> writes:
> Summary of MS:
> When it runs in ANSI mode, null != null.
> When it runs in backwards compatible mode , null=null.

Oh, that's interesting, they fixed their bug.

foo = NULL should produce NULL (*not* true, and *not* false either,
though it'd act like false in a CASE test).

Here is one vote for ripping out our parser kluge and making null act
like it should according to the spec.  Comments?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2000-08-03 14:00:37
Subject: RE: comparing rows
Previous:From: Don BaccusDate: 2000-08-03 13:52:53
Subject: Re: comparing rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group