Re: references table(multiple columns go here)

Hello again

Gary Stainburn wrote:

> Hi folks,
>
> how do I define a referene from 2 columns in 1 table to 2 columns in
> another.
>
> I have:
>
> create table ranks (
> rid int4 default nextval('ranks_rid_seq'::text) unique not null,
> rdid character references depts(did), -- department
> rrank int4 not null, -- departmental rank
> rdesc character varying(40) -- Rank Description
> );
>
>
>
>
> I would now like to define the following table so that inserts can
> only happen
> if jdid matches rdid and jrank matches rrank.
>
> create table jobtypes (
> jid int4 default nextval('jobs_jid_seq'::text) unique not null,
> jdid character references ranks(rdid), -- This joint reference
> jrank int4 not null references ranks(rrank), -- needs sorting
> jdesc character varying(40) -- job description

!!!here!!! ,CONSTRAINT c2 FOREIGN KEY(jid,jdid) REFERENCES ranks (rid,rdid)

> );

that's all
Tomasz Myrta