postgres cursors
| From: | steve shapero | Date: | Thu, 03 Oct 2002 01:07:21 +0000 |
| Subject: | postgres cursors | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22181@lists.php.net to get a copy of this message | ||
hi,
i have a function that returns a cursor. how do i get at it in php?
here's my function:
create function test3 (INTEGER) RETURNS refcursor AS '
DECLARE
cursor1 CURSOR FOR select description FROM t0040stock_item WHERE
stock_number = $1;
BEGIN
open cursor1;
return (cursor1);
END;
' LANGUAGE 'plpgsql';
thanks