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?
pgsql-general by date
|Next:||From: Tom Lane||Date: 2000-10-28 02:42:30|
|Subject: Re: Selects in server side functions |
|Previous:||From: The Hermit Hacker||Date: 2000-10-28 01:59:04|
|Subject: Re: 7.1 release date ?|