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