"Gabor Berenyi" <ber_@freemail.hu> writes:
> begin;
> declare t cursor with hold for select function() as x from R;
> commit;
> Documentation says that the rows represented by a held cursor are copied
> into a temporary file or memory area, but they are not, if they are results
> of a function call. Instead, "commit" aborts the connection.
Works for me. Could we see a complete, self-contained example?
In particular I suppose that the details of function() might be
relevant.
regards, tom lane