Array values and foreign keys

From: Daniel Savard <dsavard(at)cids(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Array values and foreign keys
Date: 2004-10-27 14:19:02
Message-ID: 2004102710192.2081413.dsavard@cids.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to define a foreign key for the values of an array?

For example, if table T1 is having a colum A which is defined as integer[] can I define a foreign key in order to force each value to be a pointer (index) to a row in a table T2?

If yes, how? Is there any shortcomings to this approach?

Thanks,

Daniel Savard

---
Daniel Savard
dsavard(at)cids(dot)ca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Deepa K 2004-10-27 14:22:10 ABRUPT CLOSURE OF POSTGRESQL SOCKET
Previous Message Carlos Oliva 2004-10-27 14:05:48 Re: Changing access permissions without re-starting the database