Folks,

Please find attached an example that allows people to return multiple
named refcursors from a function. Big kudos to Kris Jurka for
figuring this out and pasting to rafb

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Wed, Jan 12, 2005 at 09:33:30PM -0800, David Fetter wrote:
> Folks,
>
> Please find attached an example that allows people to return multiple
> named refcursors from a function. Big kudos to Kris Jurka for
> figuring this out and pasting to rafb

Oops. Joe Conway pointed out that this patch could be more succinct
and not create an essentially useless new type.

Please find attached the revised patch.

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

David Fetter <david@fetter.org> writes:
>> Please find attached an example that allows people to return multiple
>> named refcursors from a function. Big kudos to Kris Jurka for
>> figuring this out and pasting to rafb

> Oops. Joe Conway pointed out that this patch could be more succinct
> and not create an essentially useless new type.

I think the example is pretty confusing, or at least not compelling,
since it's not clear to the reader why you'd go to all that trouble
to return two scalars. The cursors ought to return rowsets.
Maybe

+ OPEN $1 FOR SELECT * FROM table1;
+ RETURN NEXT $1;
+ OPEN $2 FOR SELECT * FROM table2;
+ RETURN NEXT $2;

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Thu, Jan 13, 2005 at 01:44:58PM -0500, Tom Lane wrote:
> David Fetter <david@fetter.org> writes:
> >> Please find attached an example that allows people to return multiple
> >> named refcursors from a function. Big kudos to Kris Jurka for
> >> figuring this out and pasting to rafb
>
> > Oops. Joe Conway pointed out that this patch could be more succinct
> > and not create an essentially useless new type.
>
> I think the example is pretty confusing, or at least not compelling,
> since it's not clear to the reader why you'd go to all that trouble
> to return two scalars. The cursors ought to return rowsets.
> Maybe
>
> + OPEN $1 FOR SELECT * FROM table1;
> + RETURN NEXT $1;
> + OPEN $2 FOR SELECT * FROM table2;
> + RETURN NEXT $2;
>
> regards, tom lane

Good point. Next patch attached

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

David Fetter <david@fetter.org> writes:
> Please find attached an example that allows people to return multiple
> named refcursors from a function. Big kudos to Kris Jurka for
> figuring this out and pasting to rafb

Applied the latest version of this.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings