Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.9.1/8.9.1) with ESMTP id KAA03888 for ; Tue, 24 Nov 1998 10:07:44 -0500 (EST) (envelope-from herouth@oumail.openu.ac.il) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.8/8.8.8) with ESMTP id RAA25298; Tue, 24 Nov 1998 17:07:31 +0200 (IST) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <19981124145756.28759.qmail@desertmoon.com> References: from "Herouth Maoz" at Nov 24, 98 11:14:42 am Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 24 Nov 1998 17:08:28 +0200 To: pierre@desertmoon.com From: Herouth Maoz Subject: Re: [SQL] MINUS and slow 'not in' Cc: pgsql-sql@postgreSQL.org At 16:57 +0200 on 24/11/98, pierre@desertmoon.com wrote: > I've tried... > > insert into B > fetch 2000 from fubar; > > Which just gives a parser error. There is very little documentation on > cursors written up that I can find. I've even searched the email archives. > Ideas? Well, this usage of a cursor is not supported, as far as I know. However, if you have 6.4 (do you?), you can use SET QUERY_LIMIT to limit the number of rows fetched from the SELECT. I suppose you can set it back after you do the INSERT. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma