multiple primary keys and reference

From: Matt <matthew(dot)berardi(at)weilpublishing(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: multiple primary keys and reference
Date: 2002-06-07 20:00:01
Message-ID: 3D0110C1.5020908@weilpublishing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a table, OrderDetail, with two primary keys OrderID and ProductID

I want another table, Claims, to reference the primary keys of
OrderDetail so that the pair has to match between table not just one
attrib. I can't figure out how to do this from the docs I have. can
anyone help? thankyou in advance

matthew berardi
weil publishing

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ricardo Javier Aranibar León 2002-06-07 20:23:30 encryp pass
Previous Message Bruce Momjian 2002-06-07 19:55:52 Re: PL/pgSQL TODO