Re: [HACKERS] Re: NULL & NOT NULL

Thomas G. Lockhart wrote:
> 
> > This NULL clause is not part of constraints it is a default option and
> > we already support it,
> > prova=> CREATE TABLE table1 (field1 INTEGER DEFAULT NULL);
> > CREATE
> 
> That is certainly a clearer way of specifying it. Should we forget about
> the other syntax?
> 
>                        - Tom

Imho yes. The syntax CREATE TABLE table (field type NULL) has no sense
the NULL keyword may be used on a DEFAULT clause (if you want to specify
a default value)
or on a column constraint (if you want to avoid data integrity
violation).

1) Column Constraint definition:           [ CONSTRAINT name ] NOT NULL  
2) Default clause:           DEFAULT NULL

-Jose'-