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 FAA10766; Wed, 25 Nov 1998 05:48:44 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-hackers@postgreSQL.org id m0zicoQ-000EBQC; Wed, 25 Nov 98 12:08 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: LIMIT patch available (was: Re: [SQL] MINUS and slow 'not in') To: jwieck@debis.com Date: Wed, 25 Nov 1998 12:08:46 +0100 (MET) Cc: pierre@desertmoon.com, herouth@oumail.openu.ac.il, pgsql-sql@postgreSQL.org, pgsql-hackers@postgreSQL.org (PostgreSQL HACKERS) Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: from "Jan Wieck" at Nov 24, 98 05:07:06 pm 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. Done. URL is: ftp://ftp.postgresql.org/pub/patches/v6.4-feature-patch.tar.gz 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) #