how to return a result set from a stored procedure

From: Hugo <htakada(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to return a result set from a stored procedure
Date: 2005-06-11 12:44:32
Message-ID: f3d9ba99050611054472e0a000@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi everybody

I am trying to write a stored procedure that returns a result set but it is
not working
this is the function:
///
CREATE OR REPLACE FUNCTION
remisiones.fn_get_total_remitidoxprovision1("numeric")

RETURNS SETOF record AS
$BODY$
begin
select rm.provision as provision,
drm.producto as producto,
sum(drm.cantidad) as cantidad
FROM remisiones.remisiones rm, remisiones.detalles_remision drm
WHERE rm.remision = drm.remision and rm.provision = $1
GROUP BY rm.provision, drm.producto
ORDER BY rm.provision, drm.producto;
end;$BODY$

///
If I call this function from the interactive sql of pgadminIII I get this
result:
select * from fn_gert_total_remitidosxprovision(1)
---------------------------------------------------------------------------
row refcursor
1 <unnamed porta1>

is there a way to display the value of the rows returned, i need it becouse
I need to use it in a Datawindow definition in an Powerbuilder app.

thanks in advance

Hugo

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-06-11 13:08:04 Re: Version Control?
Previous Message Hugo 2005-06-11 12:34:02 how to return a result set from a stored procedure

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-06-11 12:47:31 Re: Proposed toast info extraction function for disaster
Previous Message Bernd Helmle 2005-06-11 11:46:17 Re: Request for Comments: ALTER [OBJECT] SET SCHEMA