| From: | steve shiflett <steve(dot)postgres(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Cursor Contents display in pgAdmin - Help. |
| Date: | 2007-04-13 17:46:53 |
| Message-ID: | 461FC20D.9060005@shiflett.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I wish to display the content 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)
COMMIT
xxx z=#
------------------------------------------------------------------------
(I am expecting the rows in the tmp.sps_measurement table.) Can anyone
help me out with this?
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Pawley | 2007-04-13 18:05:49 | Update a Value From TEdit |
| Previous Message | steve shiflett | 2007-04-13 16:42:35 | Display Cursor Content - Help! |