NULL & NOT NULL - Mailing list pgsql-general

From Bill Sneed
Subject NULL & NOT NULL
Date
Msg-id 366D3789.44FD0081@mint.net
Whole thread Raw
List pgsql-general
I'm  (1) new to postgres & (2) trying to "convert" the sample db found
in "The Practical SQL Handbook" Bowman, et al. to postgres.  When
trying to create the following table I get "parser: parse error at or
near 'null'"

create table authors (
    au_id        char(11)    not null,
    au_lname    varchar(40)    not null,
    .
    .
    .
    zip        char(5)        null
);

The table creation works fine twith the NOT NULL but won't work with
the NULL.
NULL is supported isn't it?  I can't see where I'm making a syntax
error.  Got me stumped.  TIA.

........Bill Sneed Prospect, Maine......


pgsql-general by date:

Previous
From: "Octavian-Catalin JULA"
Date:
Subject: EROR : stat failed on file /usr/local/pgsql/lib/plpgsql.so
Next
From: Dev_Al
Date:
Subject: Participate in "Freedom 64-bit CPU" project (PostgreSQL CPU!!)