Обсуждение: Tr: UNIQUE

Поиск
Список
Период
Сортировка

Tr: UNIQUE

От
"Stéphane FILLON"
Дата:
>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
>
>