On 4/13/07, Steve P Shiflett <[EMAIL PROTECTED]> wrote:
I wish to display the output of a cursor but haven't discovered the trick.
Here's what I'm doing:
According to the documentation, you can fetch from a returned
refcursor like this:
FETCH ALL IN "";
You can name the refcusor inside you
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