On Wed, Jul 8, 2009 at 6:03 AM, Alban Hertroys<dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > This is exactly the reason the 'is null' operator exists. It's exclusively > for checking for null values. You can't say 'is_deleted is true' for > example. Uh, yes you can. is false also works. and is not true and is not false. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general