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