> > Besides, I couldn't see much use in creating it as a primary
> > key. How
> > would I ever reference it from another table?
If you're questioning how to use a multi-field primary key, it's easy...
create table p (id1 int not null, id2 int not null, primary key(id1,
id2));
create table c (id1 int, id2 int, foreign key (id1, id2) references p);
insert into p values (1,2);
insert into c values (1,1);
insert into c values (1,0);
ERROR: <unnamed> referential integrity violation - key referenced from c
not found in p
--
Joel Burton <jburton@scw.org>
Director of Information Systems, Support Center of Washington
