I think that was the agreement on the best way to do it (although the
operator is even easier looking, just replace = with whatever the operator
is.). This would mean moving the array code from contrib into the real
source tree probably though, or having the foreign key stuff figure out if
you had it installed and use it only in those cases.
On Fri, 13 Oct 2000, Chris wrote:
> There is some stuff which last time I looked is in contrib that allows
> queries to test if something is in an array. Something vaguely like
> SELECT * from part, box where IN(part.num, box.array).
>
> Having this integrated in the foreign key stuff would certainly be
> important for object databases, which by definition use these kinds of
> arrays.
>
> Bruce Momjian wrote:
> >
> > > > Well, the two types aren't the same (one is an integer the
> > > > other an integer array,) so I wouldn't expect it to work. Note:
> > >
> > > Eh, I could figure that out myself. What I'm asking for is if there is a way to
> > > combine arrays with foreign keys?
> > >
> > > I believe the answer for now is 'no', but did like to get it confirmed, and
> > > also draw attention to this if someone wants to make it.
> > >
> > > > * Make sure that types used in foreign key constraints
> > > > are comparable.
> > >
> > > And maybe
> > > * Add foreign key constraint for arrays
> >
> > Added to TODO.