How do i return a dataset from a stored procedure

Поиск
Список
Период
Сортировка
От teknokrat@yahoo.com (teknokrat)
Тема How do i return a dataset from a stored procedure
Дата
Msg-id 1cbae208.0207050032.4e052f07@posting.google.com
обсуждение исходный текст
Ответы Re: How do i return a dataset from a stored procedure
Re: How do i return a dataset from a stored procedure
Список pgsql-sql
I can't figure out how to return a group of rows from a function
written in plpgsql (or plsql for that matter). The only way i have
seen it done is with a setof table return value in sql. But since the
query was a single select anyway i don't see the point of this. Is
there a way of creating a temporary table in a procedure and using it
as the output?

thanks




В списке pgsql-sql по дате отправления: