On Fri, Feb 10, 2006 at 04:48:42PM +0000, Simon Riggs wrote: > If a cursor is defined NO SCROLL, which is the SQL Standard implicit > default, then we are safe to assume there will be no rewinds or backward > scans. The PostgreSQL current implicit default is SCROLL, which means > that no part of the executor can currently make useful assumptions about > scan direction, so this is a wider issue than just sorts.
Umm, the documentation says: PostgreSQL will allow backward fetches without SCROLL, if the cursor's query plan is simple enough that no extra overhead is needed to support it. So if the default is SCROLL someone needs to fix the docs because that's not what it says. It says that *some plans* can be fetched backwards even if you don't say scroll. The documentation clearly says we don't need to support backwards searches without scroll if it causes problems. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
signature.asc
Description: Digital signature