Re: returning multiple results with stored procedures - Mailing list pgsql-general

From Joe Conway
Subject Re: returning multiple results with stored procedures
Date
Msg-id 3C17C062.3030801@home.com
Whole thread Raw
In response to User rights across databases  (Francisco Reyes <lists@natserv.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: exit status code table?
Next
From: "Thomas F. O'Connell"
Date:
Subject: mod_per, postgres, and the file system: limitations