Re: join from array or cursor - Mailing list pgsql-general

From John DeSoi
Subject Re: join from array or cursor
Date
Msg-id E3FB9BB4-4DDB-4A86-AA18-AD02B855B01A@pgedit.com
Whole thread Raw
In response to Re: join from array or cursor  (Sam Mason <sam@samason.me.uk>)
Responses Re: join from array or cursor
List pgsql-general
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.





pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Generating random unique alphanumeric IDs
Next
From: David Waller
Date:
Subject: "Number of columns exceed limit" on a hierarchy of views