Re: returning multiple results with stored procedures

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