Returning recordset from sp

Поиск
Список
Период
Сортировка
От Christian Ubbesen
Тема Returning recordset from sp
Дата
Msg-id Pine.LNX.4.21.0204131852040.19624-100000@neutron.octacom.net
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "P. Jourdan"
Дата:
Сообщение: migration still a problem
Следующее
От: Peter Lowman
Дата:
Сообщение: copy import csv problem