Re: join from array or cursor

On Aug 21, 2009, at 7:26 AM, Sam Mason wrote:

> It may help to wrap the generate_series call into a function so you
> don't have to refer to "myPkArray" so many times.

Yes, this is the best I have come up with so far. I have a set
returning function which returns the key and the index number. The
implementation with a cursor looks like this:

SELECT * FROM cursor_pk('c1') c LEFT JOIN foo ON (c.pk = foo.pk) ORDER
BY c.idx;


An array function could return the same values. I need to do some
testing to see what the performance looks likes for each method.
Thanks for the suggestion.



John DeSoi, Ph.D.