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