Re: [SQL] Unnamed Cursor return

2003-09-02 Thread Tom Lane
"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

[SQL] Unnamed Cursor return

2003-09-02 Thread Kumar
Dear Friends,   Using Postgres 7.3.4 on Linux 7.3 Server. Using PgAdmin II for Windows version 1.6.0 to connect to the server from my client machine.   CREATE FUNCTION selfn() RETURNS refcursor AS 'DECLARE ref1 refcursor;BEGINOPEN ref1 FOR SELECT *  FROM address;RETURN ref1;END;'  LANGUAGE '