Michael Fuhr wrote:

Right -- when you open a cursor PostgreSQL doesn't know how many
rows it will return.  PostgreSQL selects a query plan based on an
*estimate* of how many rows the query will return, but until you
fetch all the rows you can't know for sure how many rows there will
be.
So if i make a but data set as result of a cursor I only "pay" for the rows I actually fetch ?

/BL

---------------------------(end of broadcast)---------------------------
TIP 1: 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

Reply via email to