"Kumar" <[EMAIL PROTECTED]> writes: > (1) pls have a look in the function, that I have named the cursor as ref1, = > but again it is returning a unnamed cursor?
This is not a bug. See the "returning cursors" section of the plpgsql manual. (IIRC, you can also create a named cursor by binding the cursor in DECLARE.) > (2) How to fetch the content of the unnamed cursor at PgAdmin and at Comman= > d prompt? You probably need a BEGIN block in the psql case. Can't help you with pgadmin. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster