Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1B49B476CFD for ; Tue, 7 Jan 2003 18:30:08 -0500 (EST) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id 53E2E47736E for ; Tue, 7 Jan 2003 18:29:29 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id h07NT2X28922; Tue, 7 Jan 2003 18:29:02 -0500 (EST) From: Bruce Momjian Message-Id: <200301072329.h07NT2X28922@candle.pha.pa.us> Subject: Re: MOVE LAST: why? In-Reply-To: <27476.1041980838@sss.pgh.pa.us> To: Tom Lane Date: Tue, 7 Jan 2003 18:29:02 -0500 (EST) Cc: pgsql-hackers@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/363 X-Sequence-Number: 33973 Tom Lane wrote: > > 2002-11-12 19:44 momjian > > > > * doc/src/sgml/ref/move.sgml, src/backend/commands/portalcmds.c, > > src/backend/executor/execMain.c, src/backend/parser/gram.y, > > src/backend/parser/keywords.c, src/backend/tcop/utility.c, > > src/include/commands/portalcmds.h, src/include/nodes/parsenodes.h: > > Make MOVE/FETCH 0 actually move/fetch 0. Add MOVE LAST to move to > > end of cursor. > > Refresh my memory: what is the point of inventing an additional LAST > keyword, when the behavior is exactly the same as MOVE ALL ? SQL compatibility, per Peter. -- 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