From: Peter Eisentraut <peter_e@gmx.net>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: cataloguing NOT NULL constraints
Date: Fri, 22 Jul 2011 23:08:48 +0300
Message-ID: <1311365328.7322.1.camel@vanquo.pezone.net> (raw)
In-Reply-To: <1311172567-sup-1219@alvh.no-ip.org>
References: <20110707213401.GA27098@alvh.no-ip.org>
<1310237123.9823.1.camel@vanquo.pezone.net>
<1311172567-sup-1219@alvh.no-ip.org>
On ons, 2011-07-20 at 13:53 -0400, Alvaro Herrera wrote:
> I checked the check_constraints definition in the standard and it's
> not clear to me that NOT NULL constraints are supposed to be there at
> all. Are NOT NULL constraints considered to be CHECK constraints too?
Yes, NOT NULL is considered just a notational shorthand for CHECK (x IS
NULL).
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-hackers@postgresql.org
Cc: peter_e@gmx.net, alvherre@commandprompt.com
Subject: Re: cataloguing NOT NULL constraints
In-Reply-To: <1311365328.7322.1.camel@vanquo.pezone.net>
* 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