X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 4F850925CF0 for ; Thu, 22 May 2003 23:15:02 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 03743-08 for ; Thu, 22 May 2003 23:14:31 -0400 (EDT) Received: from tomts14-srv.bellnexxia.net (tomts14.bellnexxia.net [209.226.175.35]) by developer.postgresql.org (Postfix) with ESMTP id 1A4F092624D for ; Thu, 22 May 2003 20:32:33 -0400 (EDT) Received: from [192.168.1.200] ([64.231.213.3]) by tomts14-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030523003232.EONQ14433.tomts14-srv.bellnexxia.net@[192.168.1.200]>; Thu, 22 May 2003 20:32:32 -0400 Subject: Re: numeric fields and null From: Rod Taylor To: Don Park Cc: pgsql-sql@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-S/L+zSYVNE9Nqw0407ue" Organization: Message-Id: <1053649951.279.10.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 22 May 2003 20:32:31 -0400 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/442 X-Sequence-Number: 13607 --=-S/L+zSYVNE9Nqw0407ue Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > adhoc=3D# select id,postaladdressid from users where postaladdressid=3Dnu= ll; Given the SQL definition of NULL, =3D NULL must be false. Use postaladdressid IS NULL to do what you want. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-S/L+zSYVNE9Nqw0407ue Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+zWwe6DETLow6vwwRAmacAJ0XZ4aRSJoY9o9eeH5H8f3nckTtKQCfTxKq zgsnVAb50wRIFRG1aC8PsX8= =spIR -----END PGP SIGNATURE----- --=-S/L+zSYVNE9Nqw0407ue--