Pgsql_func_refcurfsor1
 
pgAdminII views:

Code Used :

-- Function: func_refcurfsor1(refcursor)

-- DROP FUNCTION func_refcurfsor1(refcursor);

CREATE OR REPLACE FUNCTION func_refcurfsor1(refcursor)
RETURNS refcursor AS
$BODY$
BEGIN
OPEN $1 FOR SELECT col FROM table_pgsql1;
RETURN $1;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION func_refcurfsor1(refcursor)
OWNER TO postgres;
 

SQL: Query

PHP Query :

JDBC Query :