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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
