Re: Is NULL equal to NULL or not?

scott.marlowe wrote:
> On Mon, 9 Dec 2002 jco@cornelius-olsen.dk wrote:

>>I've noticed that
>>        select NULL=NULL;
>>yields TRUE. It is also possible to select rows in this manner.
>
>
> That's NOT because null EQUALS null, but because it allowed you to assign
> one null value to another.  which technically can be done, so it came out
> true.

It *is* because null EQUALS null, on version 7.1. '=' is the
comparison operator. ':=' is the PL/pgSQL assignment operator.
Older versions of PostgreSQL allowed comparisons between NULLs
for compatibility with older versions of Access.

Mike Mascari