Received: from sardinia.gssec.bt.co.uk (sardinia.gssec.bt.co.uk [132.146.39.103] (may be forged)) by hub.org (8.9.2/8.9.1) with ESMTP id FAA79327 for ; Thu, 11 Feb 1999 05:20:41 -0500 (EST) (envelope-from maillist@remo.demon.co.uk) Received: from dhcpw198.gssec.bt.co.uk ([132.146.203.198]:3789 "HELO towhee" ident: "IDENT-NOT-QUERIED") by sardinia.gssec.bt.co.uk with SMTP id <936986-252>; Thu, 11 Feb 1999 10:12:50 +0000 From: "Neil Burrows" To: "Oleg Bartunov" Cc: Subject: RE: [SQL] setting select limit? Date: Thu, 11 Feb 1999 10:20:12 -0000 Message-ID: <000901be55a8$1bea7710$c6cb9284@towhee.gssec.bt.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-reply-to: Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Hi, > You need v6.4.2-feature-patch which implement LIMIT option: Or alternatively if you can't or don't want to apply a patch, have a look at the SET QUERY_LIMIT TO x in Postgres 6.4 Command: set Description: set run-time environment Syntax: SET DateStyle TO 'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean' set GEQO TO 'ON[=#]'|'OFF' set R_PLANS TO 'ON'| 'OFF' set QUERY_LIMIT TO # function in postgres 6.4 Regards, ---[ Neil Burrows ]----------------------------------------------------- E-mail: neil.burrows@gssec.bt.co.uk British Telecom Plc. : neil@pawprint.co.uk Glasgow Engineering Centre Web : http://www.remo.demon.co.uk/ Highburgh Rd. Glasgow UK -----------< Any views expressed are not those of my employer >-----------