Re: arrays of foreign keys

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: arrays of foreign keys
Date: 2007-09-10 14:04:12
Message-ID: 20070910090412.64a8af3b@sinkhole.intrcomm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 07 Sep 2007 23:47:40 -0000
Max <mlavenne(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message novnov 2007-09-10 14:46:17 Re: Time Zone design issues
Previous Message Richard Huxton 2007-09-10 13:45:55 Re: audit sql queries