Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group