grupos wrote:
Hi !
I am making one plpgsql function and I need to return of setof data
using a cursor.
The problem is that my function is returning only the first row and
column of the query. This query have more than 80 columns and 1.000
rows. Enyone have any tip to give me?
Yes - decide whether you are returning a set of rows or a refcursor.
Check the plpgsql docs again for how to return SETOF <rowtype> using the
RETURN NEXT statement. Then you call your function like: SELECT * FROM
my_func();
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
