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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
