Array Values and References

Started by Omachonu Ogaliover 20 years ago2 messagesgeneral
Jump to latest
#1Omachonu Ogali
missnglnk@informationwave.net

I have a table that contains my unique identifiers and their
respective values. In another table, I have a field that is an
array of integers.

Is there a simple way for one to build a constraint that checks
each array value against the primary key table even though the
field types don't exactly match? (i.e. int vs int[])

#2Joe Conway
mail@joeconway.com
In reply to: Omachonu Ogali (#1)
Re: Array Values and References

Omachonu Ogali wrote:

I have a table that contains my unique identifiers and their
respective values. In another table, I have a field that is an
array of integers.

Is there a simple way for one to build a constraint that checks
each array value against the primary key table even though the
field types don't exactly match? (i.e. int vs int[])

A trigger perhaps?

Joe