Re: [PATCH] Support for foreign keys with arrays - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [PATCH] Support for foreign keys with arrays
Date
Msg-id 1322196765.23871.5.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: [PATCH] Support for foreign keys with arrays  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On mån, 2011-11-21 at 10:30 -0600, Merlin Moncure wrote:
> I like the idea of being able to define more flexible foreign keys,
> but are we gilding the lily here?  The proposed solution is really
> quite specific to the nuances of arrays.  Perhaps there is a more
> general expression based syntax that leaves the door open for other
> types conditions such as dealing fields dependent on other fields?

Yeah, basically you'd just need a contains and/or is-contained-by
operator between the two types.



pgsql-hackers by date:

Previous
From: NISHIYAMA Tomoaki
Date:
Subject: Re: [PATCH] PostgreSQL fails to build with 32bit MinGW-w64
Next
From: Pavan Deolasee
Date:
Subject: Re: Storing hot members of PGPROC out of the band