Tr: UNIQUE

Started by Stéphane FILLONalmost 27 years ago2 messagesgeneral

fillons@offratel.nc

almost 27 years ago

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

Show quoted text

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

José Soares

jose@sferacarta.com

over 26 years ago

In reply to: Stéphane FILLON (#1)

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:

Show quoted text

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