Arrays and constraints

From: Daniel Savard <dsavard(at)cids(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Arrays and constraints
Date: 2004-10-26 20:04:54
Message-ID: 1098821097.17331.9.camel@dirac.cids.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to know if there is a way to define a constraint for the
values of an array type?

For example, if I define a table where column A is an integer[] and each
value must be an index to an element in another table. How can I do this
without the help of a third table holding relations between objects?

Is it possible? Is there any shortcomings doing things this way?

--

=======================================
Daniel Savard
=======================================

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-10-26 20:11:15 Re: Bug or stupidity
Previous Message Michael Fuhr 2004-10-26 20:04:37 Re: Error restoring bytea from dump