Received: from desertmoon.com (qmailr@desertmoon.com [198.182.124.2]) by hub.org (8.9.1/8.9.1) with SMTP id KAA05422 for ; Tue, 24 Nov 1998 10:25:43 -0500 (EST) (envelope-from pierre@desertmoon.com) From: pierre@desertmoon.com Received: (qmail 775 invoked by uid 100); 24 Nov 1998 15:31:01 -0000 Message-ID: <19981124153101.774.qmail@desertmoon.com> Date: 24 Nov 1998 08:31:01 -0700 Subject: Re: [SQL] MINUS and slow 'not in' To: herouth@oumail.openu.ac.il (Herouth Maoz) Date: Tue, 24 Nov 1998 08:31:01 -0700 (MST) Cc: pgsql-sql@postgreSQL.org In-Reply-To: from "Herouth Maoz" at Nov 24, 98 05:08:28 pm X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > 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. > Yeah I've got 6.4. I tried: set query_limit to 2000; and got: ERROR: parser: parse error at or near "2000" Ideas? -=pierre