foreign key reference on array elements?

Started by Lev Lvovskyalmost 24 years ago2 messagesgeneral
Jump to latest
#1Lev Lvovsky
lists1@sonous.com

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

#2Stephan Szabo
sszabo@megazone23.bigpanda.com
In reply to: Lev Lvovsky (#1)
Re: foreign key reference on array elements?

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.