Re: CHECK constraint removing brackets - Mailing list pgsql-sql

From Andy Shellam
Subject Re: CHECK constraint removing brackets
Date
Msg-id C433EA79-69F9-4372-B04C-D59BC94434C6@networkmail.eu
Whole thread Raw
In response to Re: CHECK constraint removing brackets  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: CHECK constraint removing brackets  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Hi Tom and Scott,

>
> I think your real problem is that you're trying to use "= NULL" and
> "!= NULL" where you should say IS NULL or IS NOT NULL.

Argh such a school-boy error!  This is the first bit of database programming I've done for about 2 months, and I hadn't
switchedmy C++ brain off. 

I know about the <> and !=, for some reason != has always made better sense to me to read, so I tend to write it that
way.

Cheers,
Andy

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: CHECK constraint removing brackets
Next
From: Tom Lane
Date:
Subject: Re: CHECK constraint removing brackets