Re: [HACKERS] Cursor behavior

2011-12-22 Thread amit sehas
It seems that the task of fetching next n results without moving the cursor seems like too complicated to implement for any query that has even a little bit of complication in it... --- On Wed, 12/21/11, Robert Haas wrote: > From: Robert Haas > Subject: Re: [HACKERS] Cursor behavio

Re: [HACKERS] Cursor behavior

2011-12-21 Thread Robert Haas
On Wed, Dec 21, 2011 at 11:44 AM, amit sehas wrote: > It seems that the task of fetching next n results without moving the cursor > seems like too complicated to implement for any query that has > even a little bit of complication in it... I think that's probably true. It would also be expensiv

Re: [HACKERS] Cursor behavior

2011-12-21 Thread Robert Haas
On Thu, Dec 15, 2011 at 4:15 PM, amit sehas wrote: > I had a question about the cursor internals implementation. When you Fetch > next 'n' results without moving the cursors, is this kind of functionality > implemented by firstly executing the whole query and then moving the cursor > over the r