Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] Support for foreign keys with arrays

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Gabriele Bartolini <gabriele(dot)bartolini(at)2ndquadrant(dot)it>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Marco Nenciarini <marco(dot)nenciarini(at)2ndquadrant(dot)it>
Subject: Re: [PATCH] Support for foreign keys with arrays
Date: 2011-11-25 04:52:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.

In response to

pgsql-hackers by date

Next:From: Pavan DeolaseeDate: 2011-11-25 04:54:23
Subject: Re: Storing hot members of PGPROC out of the band
Previous:From: NISHIYAMA TomoakiDate: 2011-11-25 04:13:12
Subject: Re: [PATCH] PostgreSQL fails to build with 32bit MinGW-w64

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group