Tom Lane wrote:
Thomas Hallgren <[EMAIL PROTECTED]> writes:Thanks Tom,
My question is, what happens when the evaluator doesn't need more rows? Will it:
a) call the function with call_cntr >= max_calls?
b) continue calling until the set is exhausted anyway?
c) simply stop calling?
(c)
a) seems unlikely since max_calls is set by the user, b) doesn't seem very optimal, and c) would be very bad since it doesn't give me any chance to release the resources that where used in order to produce the rows.
This is what RegisterExprContextCallback is for.
regards, tom lane
This is exactly what I need. I didn't know that such a callback existed. Perhaps it should be mentioned in the documentation chapter that talks about SETOF and C-functions?
Regards, Thomas Hallgren
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly