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

From Josh Trutwin
Subject Re: arrays of foreign keys
Date
Msg-id 20070910090412.64a8af3b@sinkhole.intrcomm.net
Whole thread Raw
In response to arrays of foreign keys  (Max <mlavenne@gmail.com>)
Responses Re: arrays of foreign keys
List pgsql-general
On Fri, 07 Sep 2007 23:47:40 -0000
Max <mlavenne@gmail.com> wrote:

> Hello,
>
> And pardon me if I posted this question to the wrong list, it seems
> this list is the most appropriate.
>
> 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.
>
> Is this something that one can do?

Ok - now that you have 4 replies telling you NOT to do this, if you
really decide it's how you want to proceed - it can be done by
writing your own triggers.

Personally, I would heed the advise of the other replies and seriously
consider why you want to do this.  If you decide to go against
standard normalized database practice (as is your right) feel free to
ping me off list and I can send you an example of what I've done.

Josh

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: audit sql queries
Next
From: novnov
Date:
Subject: Re: Time Zone design issues