-----Message d'origine-----
De : Stéphane FILLON <fillons@offratel.nc>
À : pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>;
pgsql-novice@postgresql.org <pgsql-novice@postgresql.org>
Date : dimanche 1 août 1999 09:12
Objet : Tr: UNIQUE
>>Hi !
>>
>>I have a table with a primary key id to have a unique tuple and
>>
>>I want to check that (fk_acount + code) is unique.
>>
>>I don't know how to create this CHECK CONSTRAINT
>>
>>create table amount(
>> id int4 constraint pk_amount primary key,
>> fk_acount int4 not null,
>> code char(3) not null
>>);
>>
>>Thanks in advance.
>>
>>Stephane
>>
>>
>