Thread: Returning recordset from sp

Returning recordset from sp

From
Christian Ubbesen
Date:
Okey, this seems like a silly question, but I just can't find the answer
anywhere.

I'm creating stored procedures in pl/pgsql. These works just fine, taking
different parameters and returning others.

But i can only return one "variable" at a time, not a complete rowset (or
"recordset").

In Oracle I think you assign the SELECT-clause to a CURSOR, and the
returns the cursor.

In T-SQL (MS SQL) you just do a SELECT and reads it back as a recordset
with ADO.

But in Postgres and pl/pgsql - how do I accomplish this?


Christian