question

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