Обсуждение: foreign key reference on array elements?

dunno if this is possible, but...

from an array, is it possible to check for a foreign key in another table
that is not an array?  do I need to make a function for this?

thanks!
-lev

On Thu, 16 May 2002, Lev Lvovsky wrote:

> dunno if this is possible, but...
>
> from an array, is it possible to check for a foreign key in another table
> that is not an array?  do I need to make a function for this?

You mean check to see that the array elements reference an existing row?
You'd need to make your own triggers to handle that, although you may
want to consider using a details table rather than an array depending on
what you're doing.