How do I return more than one value in a postgresql pl/pgsql procedure?

Поиск
Список
Период
Сортировка
От Mark Nielsen
Тема How do I return more than one value in a postgresql pl/pgsql procedure?
Дата
Msg-id 3C768665.30500@kepnet.net
обсуждение исходный текст
Ответы Re: How do I return more than one value in a postgresql pl/pgsql procedure?  (Roberto Mello <rmello@cc.usu.edu>)
Список pgsql-sql
Hello!

I am have been trying to figure out how I can get a pl/pgsql procedure 
to return more than one variable or perhaps a row. A procedure you 
create can accept more than one variable, I don't see why it shoudn't be 
able to return more than one variable in some fashion.I read rumors that  pl/pgsql can return rows (which would contain
oneor more variables 
 
per row), but I didn't find hard examples of how to do it.

What table lists the stored procedures you created with pl/pgsql or 
pl/perl? I was trying to find it with /dS in psql, but I didn't see 
anything obvious.
Thanks!
Mark



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Regular Expression for 'and' instead of 'or'
Следующее
От: "Hunter, Ray"
Дата:
Сообщение: Bench Test