Sorry to contribute to this list chaos, but I've got a question.
Yes, I know this is not normalized...
I have a table foo with key fookey.
I have a table bar which has as an attribute an array of fookeys called FK.
The number of elements in FK is variable.
I would like to:
select b.fookey, b.stuff
from foo f, bar b
where f.fookey in b.FK;
I could write a C function to turn FK into a text list, I suppose,
or create some cast of arrays to tables/set of rows.
Has anyone else already solved this problem without eliminating the
array? Have I missed some reference somewhere to arrays as lists?
thanks
elein(at)nextbus(dot)com