From: Rod Taylor <rbt@rbt.ca>
To: Don Park <don+postgresql@klickitat.st>
Cc: pgsql-sql@postgresql.org
Subject: Re: numeric fields and null
Date: 22 May 2003 20:32:31 -0400
Message-ID: <1053649951.279.10.camel@jester> (raw)
In-Reply-To: <Pine.LNX.4.51.0305221135230.14081@amidala.klickitat.st>
References: <Pine.LNX.4.51.0305221135230.14081@amidala.klickitat.st>
> 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.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rbt@rbt.ca, don+postgresql@klickitat.st
Subject: Re: numeric fields and null
In-Reply-To: <1053649951.279.10.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox