[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] numeric fields and null
From: Rod Taylor <rbt () rbt ! ca>
Date: 2003-05-23 0:32:31
[Download RAW message or body]
> adhoc=# select id,postaladdressid from users where postaladdressid=null;
Given the SQL definition of NULL, = NULL must be false.
Use postaladdressid IS NULL to do what you want.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
["signature.asc" (application/pgp-signature)]
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic