Re: [GENERAL] Tr: UNIQUE

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(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
> >>
> >>
> >