Re: [HACKERS] Re: [QUESTIONS] Practical SQL Handbook - demo script for postgreSQL - Mailing list pgsql-hackers

From Bruce Stephens
Subject Re: [HACKERS] Re: [QUESTIONS] Practical SQL Handbook - demo script for postgreSQL
Date
Msg-id m37m4b3weo.fsf@cenderis.demon.co.uk
Whole thread Raw
In response to Re: [QUESTIONS] Practical SQL Handbook - demo script for postgreSQL  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu> writes:

> Don't know how or if we want to proceed with a bare "NULL" clause.
> Should we bother with a special case of _only_ NULL in a
> declaration, as in Bruce's patch?

My patch is clearly wrong.  The NULL should be parallel to NOT NULL,
and ought just to be ignored (since NULL is the default).  I think
it's worth doing (as the book says, NULL may not be the default on
your system, and anyway, it's always better to specify just for
clarity).

I think explicitly specifying NULL is probably good practice, so it
should be supported.

pgsql-hackers by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [HACKERS] Re: [QUESTIONS] Practical SQL Handbook - demo scrip t for postgreSQL
Next
From: Byron Nikolaidis
Date:
Subject: New Driver and Unique Indexes