Postgres Pro
Downloads
Home   >   mailing lists

Re: numeric fields and null - Mailing list pgsql-sql

From Rod Taylor
Subject Re: numeric fields and null
Date
Msg-id 1053649951.279.10.camel@jester
Whole thread Raw
In response to numeric fields and null  (Don Park <don+postgresql@klickitat.st>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: Don Park
Date:
Subject: Re: numeric fields and null
Next
From: Rod Taylor
Date:
Subject: Re: tablename as attribute in pgplsql