| 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: | Whole Thread | Raw Message | 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 ...' |