Re: returning multiple results with stored procedures

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: returning multiple results with stored procedures
Дата
Msg-id 3C17C062.3030801@home.com
обсуждение исходный текст
Ответ на User rights across databases  (Francisco Reyes <lists@natserv.com>)
Список pgsql-general
Geoffrey J. Gowey wrote:

> I was wandering through the source on how to send back multiple rows and
> columns and stumbled apon ExprMultipleResult mentioned in the README in
> src/backend/utils/fmgr/.  Unfortunately, I'm not sure if this is or is
> not what I'm looking for.  There's very little code using this feature
> and I could not find any documentation.  Can anyone explain to me if
> this is what I need and, if so, how to implement it using Version 1
> style coding as well as any other helpful pieces of information?
>

You can return multiple rows, but not really multiple columns directly
(at least not yet). See contrib/dblink in the 7.2 beta for an example.

HTH,

--Joe


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: exit status code table?
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: mod_per, postgres, and the file system: limitations