"Gabor Berenyi" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to