Re: [PERFORM] refcurosr vs. setof

2005-04-18 Thread Michael Fuhr
On Sun, Apr 17, 2005 at 10:05:29PM +0200, RĂ¼diger Herrmann wrote: 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

[PERFORM] refcurosr vs. setof

2005-04-17 Thread RĂ¼diger Herrmann
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