Thread: question

Hi
There is question. I have column name_my varchar (not array) in table1,
and column name_my_ref  varchar[] (array) in  other table2.   I want set
Foreign Key on name_my_ref  and  every element in the same  row of array
must match any element in name_my. How can  I  do this?

On Tuesday 04 November 2003 16:50, Alexandr S wrote:
> Hi
> There is question. I have column name_my varchar (not array) in table1,
> and column name_my_ref  varchar[] (array) in  other table2.   I want set
> Foreign Key on name_my_ref  and  every element in the same  row of array
> must match any element in name_my. How can  I  do this?

You'll have to write your own trigger functions AFAIK.

It looks to me like you want another table, rather than arrays here.
--
  Richard Huxton
  Archonet Ltd