Message-ID: <017b01c31a38$f8cf1ec0$0a03a8c0@fejleszt2>
From: =?iso-8859-1?Q?SZUCS_G=E1bor?= <surrano@mailbox.hu>
To: <pgsql-sql@postgresql.org>
References: <000b01c314aa$70f58400$f100000a@IT001>
Subject: Re: array in a reference
Date: Wed, 14 May 2003 18:50:48 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Ries,

----- Original Message -----
From: "Ries van Twisk" <ries@jongert.nl>
Sent: Wednesday, May 07, 2003 5:07 PM


> CREATE TABLE t0 {
> id SERIAL,
> value TEXT
> }
>
> CREATE TABLE t1 {
> id SERIAL,
> t0id INTEGER[] REFERENCES t0(id)     -- <<<< Is this possible????
> }


I'd use a third table:

  CREATE TABLE t1 (
    id SERIAL
  );

  CREATE TABLE t1_refs_t0 (
    t0id integer NOT NULL REFERENCES t0(id),
    t1id integer NOT NULL REFERENCES t1(id)
-- Probably you'd like to add some unique constraint (if the orig. array
-- shouldn't contain equal values):
    , UNIQUE (t1id, t0id)
  );

And maybe a trigger (after insert/update on t1) to check that actually there
are rows in the refs table for the new t1.id, but I can't really find out
the correct syntax now :)

G.
--
while (!asleep()) sheep++;

---------------------------- cut here ------------------------------