X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B42974758BD for ; Tue, 4 Feb 2003 06:23:30 -0500 (EST) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id 2CA0D474E53 for ; Tue, 4 Feb 2003 06:23:29 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id h14BND004292; Tue, 4 Feb 2003 06:23:13 -0500 (EST) From: Bruce Momjian Message-Id: <200302041123.h14BND004292@candle.pha.pa.us> Subject: Re: MOVE LAST: why? In-Reply-To: <3E3F21DA.DC6D43EB@tpf.co.jp> To: Hiroshi Inoue Date: Tue, 4 Feb 2003 06:23:13 -0500 (EST) Cc: Tom Lane , pgsql-hackers@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary=ELM1044357793-17362-0_ Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/199 X-Sequence-Number: 35141 --ELM1044357793-17362-0_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII Hiroshi Inoue wrote: > Bruce Momjian wrote: > > > > It also clarifies the docs to mention it sits on the last row, not after > > the last row. > > Is it true ? Oops. I thought we didn't match the spec because we _didn't_ go past the last row, but now I see it is because we do go past the last row. Patch applied to revert. Thanks. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 --ELM1044357793-17362-0_ Content-Transfer-Encoding: 7bit Content-Type: text/plain Content-Disposition: inline; filename="/bjm/diff" Index: doc/src/sgml/ref/fetch.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/ref/fetch.sgml,v retrieving revision 1.24 diff -c -c -r1.24 fetch.sgml *** doc/src/sgml/ref/fetch.sgml 3 Feb 2003 14:04:24 -0000 1.24 --- doc/src/sgml/ref/fetch.sgml 4 Feb 2003 11:21:20 -0000 *************** *** 209,221 **** The cursor position can be before the first row of the query result, or on ! any particular row of the result. When created, a cursor is positioned before the first row. After fetching some rows, the cursor is positioned on the last row retrieved. A new FETCH always steps one row in the specified direction (if possible) before beginning to return rows. If the FETCH requests more rows than available, the cursor is ! left positioned on the last row of the query result (or on the first row, in the case of a backward fetch). This will always be the case after FETCH ALL. --- 209,221 ---- The cursor position can be before the first row of the query result, or on ! any particular row of the result, or after the last row of the result. When created, a cursor is positioned before the first row. After fetching some rows, the cursor is positioned on the last row retrieved. A new FETCH always steps one row in the specified direction (if possible) before beginning to return rows. If the FETCH requests more rows than available, the cursor is ! left positioned after the last row of the query result (or before the first row, in the case of a backward fetch). This will always be the case after FETCH ALL. *************** *** 225,231 **** A zero row count requests fetching the current row without moving the cursor --- that is, re-fetching the most recently fetched row. This will succeed unless the cursor is positioned before the ! first row; in which case, no row is returned. --- 225,231 ---- A zero row count requests fetching the current row without moving the cursor --- that is, re-fetching the most recently fetched row. This will succeed unless the cursor is positioned before the ! first row or after the last row; in which case, no row is returned. Index: doc/src/sgml/ref/move.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/ref/move.sgml,v retrieving revision 1.17 diff -c -c -r1.17 move.sgml *** doc/src/sgml/ref/move.sgml 3 Feb 2003 14:04:24 -0000 1.17 --- doc/src/sgml/ref/move.sgml 4 Feb 2003 11:21:20 -0000 *************** *** 35,41 **** MOVE allows the user to move the cursor position a specified number of rows, or to the beginning or end of the cursor. ! MOVE ALL moves to the last row of the cursor. MOVE works exactly like the FETCH command, except it only repositions the cursor and does not return rows. --- 35,41 ---- MOVE allows the user to move the cursor position a specified number of rows, or to the beginning or end of the cursor. ! MOVE ALL moves to the end of the cursor. MOVE works exactly like the FETCH command, except it only repositions the cursor and does not return rows. --ELM1044357793-17362-0_--