From: "Filipe Bonjour" <fbonjour@urbanet.ch>
Subject: Can arrays reference primary keys in CREATE TABLE?
Date: Fri, 09 May 2003 23:21:25 +0200
User-Agent: Pan/0.13.3 (That cat's something I can't explain)
Message-ID: <pan.2003.05.09.21.21.24.908732@urbanet.ch>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Lines: 31
To: pgsql-sql@postgresql.org
Content-Transfer-Encoding: quoted-printable

Hi,

I'm a rather new SQL user, and I found interesting that you can
use "references" to make sure that a value inserted in a table is a
primary key from another table. Something like:

create table ta (
  a_id     integer primary key
  );
create table tb (
  a_ref     integer references ta(a_id)
  );

However, I'd like to define a table containing an array, and that
all elements of the array be a primary key from another table, so I
tried:

create table tb (
  a_ref     integer[] references ta(a_id)
  );

But that doesn't work, I think because an array of integers can't
be directly compared to an integer.

Is there a way to do this? (I'm using Red Hat 9 with PostgreSQL 7.3.2,
by the way.)

Thanks in advance for any answer or for pointing our where I can find
it.

Fil