Re: Number of rows in a cursor ? - Mailing list pgsql-sql

From Bo Lorentsen
Subject Re: Number of rows in a cursor ?
Date
Msg-id 430D6A8F.6000404@netgroup.dk
Whole thread Raw
In response to Re: Number of rows in a cursor ?  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Number of rows in a cursor ?
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Can EXCEPT Be Used for To Solve This Problem?
Next
From: Daniel Silverstone
Date:
Subject: table listing queries