[GENERAL] display cursor contents

[Steve P Shiflett]

I wish to display the output of a cursor but haven't discovered the trick.
Here's what I'm doing:

-- The function


CREATE OR REPLACE FUNCTION tmp.sps(character varying, date)
  RETURNS refcursor AS
$BODY$
DECLARE
  ref refcursor;
BEGIN
      OPEN ref FOR select * from tmp.sps_measurement  where logdate < $2;
      RETURN  ref;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;

-- psql script expected to display the contents of the cursor

BEGIN;

declare
ref cursor for select tmp.sps('=','2006-06-12') ;

FETCH all IN ref;
commit;

-- Output:

xxx z=#  \i sps_test.sql
BEGIN
DECLARE CURSOR
        sps
--------------------
 <unnamed portal 9>
(1 row)


(I am expecting the rows in the tmp.sps_measurement table.)  Can anyone
help me out with this?

STEve
COMMIT
mdc_oz=#




Steve Shiflett
Operations Engineer
macys.com
415.422.1416
[EMAIL PROTECTED]
AIM/ICQ: spsshiflett


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings