Received: from mail.offratel.nc (FS25.offratel.nc [209.58.55.25]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA69249; Sat, 31 Jul 1999 18:13:07 -0400 (EDT) (envelope-from fillons@offratel.nc) Received: from portable (unverified [209.58.55.147]) by mail.offratel.nc (Rockliffe SMTPRA 3.3.1) with SMTP id ; Sun, 1 Aug 1999 09:12:36 +1100 Message-ID: <001f01bedba1$c5e52920$c40a8280@portable> Reply-To: "=?iso-8859-1?Q?St=E9phane_FILLON?=" From: "=?iso-8859-1?Q?St=E9phane_FILLON?=" To: , Subject: Tr: UNIQUE Date: Sun, 1 Aug 1999 09:12:25 +1100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 >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 > >