Received: from proxy.sferacarta.com (root@ppp01-nas3.nettuno.it [193.207.156.234]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA24635 for ; Thu, 6 Aug 1998 10:07:25 -0400 (EDT) Received: from mail.sferacarta.com (blu.sferacarta.com [10.20.30.12]) by proxy.sferacarta.com (8.8.8/8.8.8/Debian/GNU) with SMTP id QAA08523; Thu, 6 Aug 1998 16:00:46 GMT Date: Thu, 6 Aug 1998 16:09:20 +0200 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <5673.980806@bo.nettuno.it> To: pgsql-sql@postgreSQL.org, Colin Dick Subject: Re: [SQL] Creating table with unique key. References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Hello Colin, mercoledì, 5 agosto 98, you wrote: >> > CREATE TABLE cliente ( >> > name varchar(100) UNIQUE NOT NULL, >> > username varchar(8) NOT NULL , >> > key int4 NOT NULL DEFAULT nextval('key_s') PRIMARY KEY, >> > ); CD> Hi this is from a previous post regarding auto-incrementing. I have that CD> part working, now I am trying to create a table with a field which will CD> not be null and will be unique to the rest of table. Is this possible and CD> what is the correct syntax. I have tried and receeved the following: CD> CREATE TABLE cust (FileNumber int4 unique not null, CompName varchar(50), CD> FirstName varchar(50), LastName varchar(50), BirthDate varchar(8), Suite CD> varchar(5), Address varchar(50), City varchar(20), Province varchar(20), CD> PostalCode varchar(7), Email varchar(50), HomePhone varchar(14), WorkPhone CD> varchar(14), FaxPhone varchar(14)); CD> WARN:parser: parse error at or near "unique" CD> Can someone point me in the right direction. Thanks. CD> -- CD> Colin Dick CD> On Call Internet Services CD> cdick@mail.ocis.net The syntax is correct for v6.3.2 and it works for me, maybe you have an older release of PostgreSQL. Best regards, Jose' mailto:sferac@bo.nettuno.it