novnov escribió: > > I have been able to run a test like you have in a query (if that's the right > term), and ORDER BY does work. When trying to run via psql, it fails, I > can't see what I'm doing wrong. (windows xp, postgres 8.2.0-1) > > ups=# select proc_item_list(1,true); > proc_item_list > -------------------- > <unnamed portal 3> > (1 row) > > ups=# fetch all from "<unnamed portal 3>"; > ERROR: cursor "<unnamed portal 3>" does not exist > ups=#
Cursors are closed when transactions finish. Try issuing a BEGIN before calling the function (and COMMIT after the fetch). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
