From: | "Fernando Papa" <fpapa(at)claxson(dot)com> |
---|---|
To: | <pgsql-php(at)postgresql(dot)org> |
Subject: | Retriving cursor from pgplsql function |
Date: | 2002-10-21 13:23:02 |
Message-ID: | CB94A4924490EC4A81EDA55BA378B7BA283890@exch2k01.buehuergo.corp.claxson.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
Hi everibody.
I'm new on postgres stuffs... I'm trying to create several functions to
encapsulate "bussines procedures"... actually I need to return a cursor.
This is the "head" of function:
--------------
create or replace function match(refcursor,int8) returns refcursor
as '
DECLARE
vid ALIAS FOR $2;
vcursor ALIAS FOR $1;
BEGIN
(...)
return vcursor;
(...)
--------------
And this is php call:
--------------
$conn = pg_pconnect ($conn_string);
$qry = "BEGIN; SELECT matche('cursorsalida',$identificador); fetch
all in cursorsalida; ";
$result = pg_query ($conn, $qry);
$num = pg_num_rows($result);
for ($i=0; $i < $num; $i++) {
$r = pg_fetch_row($result, $i);
(...)
---------------
The problem with this is than I need to pass the cursor to the
function... when I try to create a function who doesn't receive a
"refcursor" (only "return" the refcursor), I can't use the cursor!
I think I'm not doing this in the best way... actually this works fine,
but I don't want to pass by parameter a cursor...
Thanks in advance!
--
Fernando O. Papa
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Wright | 2002-10-21 15:31:09 | Re: building on OS X |
Previous Message | Shane Wright | 2002-10-20 13:37:07 | building on OS X |