-----Message d'origine----- De : Stéphane FILLON <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 >> >> >
