From: Andy Shellam <andy-lists@networkmail.eu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: CHECK constraint removing brackets
Date: Mon, 11 Jan 2010 23:27:35 +0000
Message-ID: <C433EA79-69F9-4372-B04C-D59BC94434C6@networkmail.eu> (raw)
In-Reply-To: <18738.1263240918@sss.pgh.pa.us>
References: <D884BF27-7555-40BA-8A5E-CAEE1272CE26@networkmail.eu>
<18738.1263240918@sss.pgh.pa.us>
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 switched my 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andy-lists@networkmail.eu, tgl@sss.pgh.pa.us
Subject: Re: CHECK constraint removing brackets
In-Reply-To: <C433EA79-69F9-4372-B04C-D59BC94434C6@networkmail.eu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox