Saturday, September 20, 2008

Re: [HACKERS] Foreign key constraint for array-field?

On Sun, Sep 21, 2008 at 04:38:56AM +0400, Dmitry Koterov wrote:
> Hello.
>
> Is it possible to create a foreign key constraint for ALL elements of
> an array field?

Whether it's possible or not--it probably is--it's a very bad idea.
Just normalize :)

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

No comments: