From: | Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org, Colin Dick <cdick(at)mail(dot)ocis(dot)net> |
Subject: | Re: [SQL] Creating table with unique key. |
Date: | 1998-08-06 14:09:20 |
Message-ID: | 5673.980806@bo.nettuno.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
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(at)mail(dot)ocis(dot)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(at)bo(dot)nettuno(dot)it
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-08-06 15:34:09 | Re: [HACKERS] Large objects names |
Previous Message | David Hartwig | 1998-08-06 13:14:44 | Re: [HACKERS] Large objects names |
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Johnson | 1998-08-06 14:38:49 | Re: [SQL] What is the recommended machine configuration? |
Previous Message | Tom Good | 1998-08-06 12:20:04 | Re: [SQL] What is the recommended machine configuration? |