Re: Bug #765: 'IS NULL' versus '= NULL' - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: Bug #765: 'IS NULL' versus '= NULL'
Date
Msg-id Pine.LNX.4.44.0209141551250.1307-100000@localhost.localdomain
Whole thread Raw
In response to Bug #765: 'IS NULL' versus '= NULL'  (pgsql-bugs@postgresql.org)
List pgsql-bugs
> Eventhough my_table contain a record with id as null, the last 2 sqls
> are not resulting that record. Why?

Because they're not the right commands to do that kind of thing.  Please
read the chapter on operators and functions in the User's Guide.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #766: version difference creates problem
Next
From: Peter Eisentraut
Date:
Subject: Re: Bug #766: version difference creates problem