Re: numeric fields and null

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Don Park <don+postgresql(at)klickitat(dot)st>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: numeric fields and null
Date: 2003-05-23 00:32:31
Message-ID: 1053649951.279.10.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2003-05-23 00:41:24 Re: tablename as attribute in pgplsql
Previous Message Don Park 2003-05-22 23:25:13 Re: numeric fields and null