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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq