Received: from mint.mint.net (mint.mint.net [204.254.98.16]) by hub.org (8.9.1/8.9.1) with ESMTP id JAA19274 for ; Tue, 8 Dec 1998 09:25:10 -0500 (EST) (envelope-from bsneed@mint.net) Received: from mint.net (root@ddialup-r-48.mint.net [208.220.38.68]) by mint.mint.net (8.8.8/8.8.8) with ESMTP id JAA05352 for ; Tue, 8 Dec 1998 09:25:09 -0500 Sender: root@mint.mint.net Message-ID: <366D3789.44FD0081@mint.net> Date: Tue, 08 Dec 1998 14:28:25 +0000 From: Bill Sneed X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.34 i586) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-general@hub.org" Subject: NULL & NOT NULL Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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......