NULL & NOT NULL

From: Bill Sneed <bsneed(at)mint(dot)net>
To: "pgsql-general(at)hub(dot)org" <pgsql-general(at)hub(dot)org>
Subject: NULL & NOT NULL
Date: 1998-12-08 14:28:25
Message-ID: 366D3789.44FD0081@mint.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1998-12-08 14:46:51 Re: [GENERAL] NULL & NOT NULL
Previous Message Octavian-Catalin JULA 1998-12-08 07:18:14 EROR : stat failed on file /usr/local/pgsql/lib/plpgsql.so

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1998-12-08 14:46:51 Re: [GENERAL] NULL & NOT NULL
Previous Message Petter Reinholdtsen 1998-12-08 11:54:44 Oracle SQL 'comment on ...'