Skip site navigation (1) Skip section navigation (2)

What is wrong with this query?

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 (view raw or flat)
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



pgsql-general by date

Next:From: Henrique PantarottoDate: 2000-02-28 18:20:06
Subject: RE: RES: [GENERAL] Stored procedures returning multiple values... ?
Previous:From: Bruce MomjianDate: 2000-02-28 17:25:05
Subject: Re: [GENERAL] psql 7.0.0 beta

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group