Re: Arrays and foreign keys

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.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026