Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.1/8.9.1) with SMTP id KAA06705 for ; Tue, 24 Nov 1998 10:39:38 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m0ziKza-000EBbC; Tue, 24 Nov 98 17:07 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] MINUS and slow 'not in' To: pierre@desertmoon.com Date: Tue, 24 Nov 1998 17:07:06 +0100 (MET) Cc: herouth@oumail.openu.ac.il, pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: <19981124153101.774.qmail@desertmoon.com> from "pierre@desertmoon.com" at Nov 24, 98 08:31:01 am X-Mailer: ELM [version 2.4 PL25] Content-Type: text > Yeah I've got 6.4. I tried: > > set query_limit to 2000; > > and got: > > ERROR: parser: parse error at or near "2000" > > Ideas? I think you must use '2000' instead. Anyway, the "set query_limit" will disappear again in v6.5 (at least) because it potentially can break rewrite rule system semantics. Instead you might want to use the LIMIT/OFFSET patch I've created in the v6.4 feature patch. This is what will be in v6.5. I'll take a look how I can put it onto the server and drop a note here after. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #