Re: cataloguing NOT NULL constraints

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: cataloguing NOT NULL constraints
Date: 2011-07-22 20:08:48
Message-ID: 1311365328.7322.1.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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).

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2011-07-22 20:25:34 Re: Policy on pulling in code from other projects?
Previous Message Robert Haas 2011-07-22 19:54:03 Re: sinval synchronization considered harmful