Re: arrays of foreign keys - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: arrays of foreign keys
Date
Msg-id 08D6AF7A-52ED-40DC-8004-CA02753EEF2D@seespotcode.net
Whole thread Raw
In response to arrays of foreign keys  (Max <mlavenne@gmail.com>)
List pgsql-general
On Sep 7, 2007, at 18:47 , Max wrote:

> I am trying to create a table with an array containing foreign keys.
> I've searched through the documentation and couldn't find a way to do
> so.

It's because this is not how relational databases are designed to
work. From the server's point of view, an array is an opaque
structure, to be treated as a whole. You're working against the
system here.

> I know I can solve my problem with the following table:

And this is how you should do it.

Michael Glaesemann
grzm seespotcode net



pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: arrays of foreign keys
Next
From: "Rodrigo De León"
Date:
Subject: Re: audit sql queries