"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