Re: Return unknown resultset from a function - Mailing list pgsql-general

From Tom Lane
Subject Re: Return unknown resultset from a function
Date
Msg-id 12092.1330963706@sss.pgh.pa.us
Whole thread Raw
In response to Re: Return unknown resultset from a function  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Return unknown resultset from a function
List pgsql-general
Merlin Moncure <mmoncure@gmail.com> writes:
> The only exception to this rule is cursors.  Reading from cursors via
> FETCH allows you to pull data from a refcursor that was set up in a
> previous function call and works pretty well, but comes with the giant
> downside that the results can be directed only to the client.

Hmm, couldn't you do a FETCH into a record variable in plpgsql?  Not
that you'd not have problems manipulating the record variable, since
plpgsql is pretty strongly typed itself.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Memory usage and configuration settings
Next
From: Mike C
Date:
Subject: Re: Memory usage and configuration settings