| From: | "Jackson, Kevin J(dot)" <KJJACKS(at)twa(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | What is wrong with this query? |
| Date: | 2000-02-28 18:10:34 |
| Message-ID: | 9D546E233EDED21180EC0090273C5BAD01D65912@twakcax2.twa.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Here's the query:
CREATE TABLE project_request (submit_date date ,
projectid serial ,
contact varchar not null ,
department varchar not null ,
telephone varchar not null ,
email varchar not null ,
project_name varchar not null ,
projectgoal1 varchar not null ,
projectgoal2 varchar ,
projectgoal3 varchar ,
projectgoal4 varchar ,
projectgoal5 varchar ,
projectgoal6 varchar ,
projectgoal7 varchar ,
PRIMARY KEY (projectid),
INDEX (projectid, project_name, email),
UNIQUE (projectid, project_name));
Here's the error I message I get:
ERROR: parser: parse error at or near "("
Please respond by email, as I am currently unable to get the list here at
work. (Curse those corprate amerver sysadmins!)
TIA!
Kevin J. Jackson
Internet Support/Development Specialist
TWA
kjjacks(at)twa(dot)com
http://www.twa.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henrique Pantarotto | 2000-02-28 18:20:06 | RE: RES: [GENERAL] Stored procedures returning multiple values... ? |
| Previous Message | Bruce Momjian | 2000-02-28 17:25:05 | Re: [GENERAL] psql 7.0.0 beta |