Try this:
create table amount(
id int4 constraint pk_amount primary key,
fk_acount int4 not null,
code char(3) not null,
constraint unico unique (fk_acount, code)
);
José
Stéphane FILLON ha scritto:
> -----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
> >>
> >>
> >