refcurosr vs. setof - Mailing list pgsql-performance

From Rüdiger Herrmann
Subject refcurosr vs. setof
Date
Msg-id d3ugoo$2oq8$1@news.hub.org
Whole thread Raw
Responses Re: refcurosr vs. setof  (Michael Fuhr <mike@fuhr.org>)
List pgsql-performance
Hello,

I need to write several PL/pgSQL functions all returning a "result set" wich
can be obtained by a single SELECT statement.
For now the functions are called by a Java application.
Both REFCURSOR and SETOF serve my purpose, but I was wondering if there is a
perfonance difference between the two. The result set can become quite
large.

I hope not to ask this question the 1001 time, though I couldn't find
anything on the net.. Any hints are welcome.

Regards
R�diger



pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: plperl vs plpgsql
Next
From: Christopher Browne
Date:
Subject: Re: plperl vs plpgsql