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

[HACKERS] Cursor behavior

2011-12-18 Thread amit sehas
HI, 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 results, or are the movements done on active database lo