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