Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g03Nm4m87668 for ; Thu, 3 Jan 2002 18:48:05 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 846F7D5E5; Thu, 3 Jan 2002 15:48:06 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 7A2F45BF1; Thu, 3 Jan 2002 15:48:06 -0800 (PST) Date: Thu, 3 Jan 2002 15:48:06 -0800 (PST) From: Stephan Szabo To: Richard Rowell Cc: Subject: Re: top? In-Reply-To: <20020103233110.WNDG17507.imf05bis.bellsouth.net@there> Message-ID: <20020103154644.J15005-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200201/28 X-Sequence-Number: 6119 On Thu, 3 Jan 2002, Richard Rowell wrote: > Just wondering if there was a "TOP" equivilant in Postgres? > IE > select top 1 * from froo > (only returns 1 row) select * from froo limit 1; Usually you'll want to order as well so that you get a meaningfully chosen row rather than whatever row happens to be scanned first.