Re: [SQL] Creating table with unique key.

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