Tr: UNIQUE

-----Message d'origine-----
De : Stéphane FILLON <fillons(at)offratel(dot)nc>
À : pgsql-sql(at)postgresql(dot)org <pgsql-sql(at)postgresql(dot)org>;
pgsql-novice(at)postgresql(dot)org <pgsql-novice(at)postgresql(dot)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
>>
>>
>