Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.2/8.9.1) with SMTP id EAA70879 for ; Thu, 11 Feb 1999 04:09:00 -0500 (EST) (envelope-from wieck@sapserv.debis.de) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgreSQL.org id m10AsDU-000EBRC; Thu, 11 Feb 99 10:15 MET Message-Id: From: jwieck@debis.com (Jan Wieck) Subject: Re: [SQL] setting select limit? To: fmorton@base2inc.com (Frank Morton) Date: Thu, 11 Feb 1999 10:15:24 +0100 (MET) Cc: pgsql-sql@postgreSQL.org Reply-To: jwieck@debis.com (Jan Wieck) In-Reply-To: <01ae01be555f$0390d4f0$8355e5ce@base2inc.com> from "Frank Morton" at Feb 10, 99 08:36:57 pm X-Mailer: ELM [version 2.4 PL25] Content-Type: text > > If a select is going to match 1000 records, but I only want to > select the first 25, I thought I could: > > select * from table limit 25; > > But I guess I can't. How do I limit the query? I've search > around with no results. Thanks. Exactly that syntax is provided for v6.4 in the feature patch you find in the patches directory of the ftp server. And it will be in the standard distribution of v6.5. 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) #