Returning recordset from sp - Mailing list pgsql-novice

From Christian Ubbesen
Subject Returning recordset from sp
Date
Msg-id Pine.LNX.4.21.0204131852040.19624-100000@neutron.octacom.net
Whole thread Raw
List pgsql-novice
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



pgsql-novice by date:

Previous
From: "P. Jourdan"
Date:
Subject: migration still a problem
Next
From: Peter Lowman
Date:
Subject: copy import csv problem