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 KAA06069 for ; Tue, 24 Nov 1998 10:32:28 -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 RAA25683; Tue, 24 Nov 1998 17:32:10 +0200 (IST) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <19981124153101.774.qmail@desertmoon.com> References: from "Herouth Maoz" at Nov 24, 98 05:08:28 pm Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 24 Nov 1998 17:32:59 +0200 To: pierre@desertmoon.com From: Herouth Maoz Subject: Re: [SQL] MINUS and slow 'not in' Cc: pgsql-sql@postgreSQL.org At 17:31 +0200 on 24/11/98, pierre@desertmoon.com wrote: > > Yeah I've got 6.4. I tried: > > set query_limit to 2000; > > and got: > > ERROR: parser: parse error at or near "2000" > > Ideas? Well, I don't have 6.4 as yet. However, reading the manpage, I surmise that the value passed is a string value (To support "SET QUERY_LIMIT TO 'unlimited'"). Thus, try quoting the 2000... Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma