Tr: UNIQUE - Mailing list pgsql-sql

From Stéphane FILLON
Subject Tr: UNIQUE
Date
Msg-id 001f01bedba1$c5e52920$c40a8280@portable
Whole thread Raw
List pgsql-sql
>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
>
>



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Outer Joins, Foreign keys, subselects
Next
From: "Stéphane FILLON"
Date:
Subject: Tr: DUMP database for sample