grupos wrote:
Hi Richard,
Thanks for your promptly answer. I don't have experience returning
refcursor but my choice would be it.
I read the documentation but I didn't find any example with my
necessity...
Could you give me a small example on the same "basis" that I want?
Thanks,
Rodrigo Carvalhaes
Richard Huxton wrote:
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();
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
There is a standard way :
Select * from memberstatus A where not exists
(select * from emberstatus B where B.member_id=A.member_id and
B.status_date >A.status_date)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
