CREATE OR REPLACE FUNCTION fnc_get_data ()
RETURNS REFCURSOR AS
$BODY$
DECLARE
   rc   REFCURSOR;
BEGIN
   OPEN rc FOR
      SELECT *
      FROM   pg_user;

   RETURN rc;
END;
$BODY$
LANGUAGE 'plpgsql';


BEGIN;
SELECT * FROM fnc_get_data (); /* SELECT fnc_get_data (); */

          fnc_get_data
      --------------------
       <unnamed portal  1 >
      ( 1  row)


FETCH FORWARD  5  FROM "<unnamed portal 1>";

       usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig
      ----------+----------+-------------+----------+-----------+----------+----------+-----------
       xc_test  |   1060868  | f           | f        | f         | ******** |          |
       postgres |        10  | t           | t        | t         | ******** |          |
       abc      |     16389  | f           | f        | f         | ******** |          |
       power_qa |     20267  | t           | t        | t         | ******** |          |
       opencms  |     20499  | t           | t        | t         | ******** |          |
      ( 5  rows)

ROLLBACK; /* COMMIT; */

<?php
include_once("../gps_vars.php");
$sql = "begin; select * from gps.tst_func('2007-05-28'::date, 14); fetch all from cur1; commit;";
$res = pg_query($sql);
echo "\$res=".$res."<br><br>";
while ($row = pg_fetch_array($res)) {
	echo $row[ 0 ];
        echo "<br>";
}
pg_free_result($res);
pg_close($link);
?>