Question on stored functions

Поиск
Список
Период
Сортировка
От Gunjeet Singh
Тема Question on stored functions
Дата
Msg-id 200403031851.i23IpjR5444302@jurassic.eng.sun.com
обсуждение исходный текст
Ответы Re: Question on stored functions  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Question on stored functions  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
Hi,

I could only find support for defining functions in pl/pgsql.
With a function I can have only one return value. What if I need
to have multiple OUT parameters (i.e multiple return values) ?
Is there any support for something that is similar to an Oracle
stored procedure ?

I understand that I can return a REFCURSOR from a postgres function,
but my question is for a case, say, where I need to return 2 string
variables/values based on some logic in addition to a REFCURSOR.
How do I do that in pl/pgsql ?

Thanks,

Gunjeet


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

Предыдущее
От: "Gavin M. Roy"
Дата:
Сообщение: Re: 7.4.1 upgrade issues
Следующее
От: Bricklen
Дата:
Сообщение: autocommit to off?