scott.marlowe wrote:
> On Mon, 9 Dec 2002 jco(at)cornelius-olsen(dot)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