"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