Received: from imf05bis.bellsouth.net (mail205.mail.bellsouth.net [205.152.58.145]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g03NTxm85686 for ; Thu, 3 Jan 2002 18:30:00 -0500 (EST) (envelope-from rwrowell@bellsouth.net) Received: from there ([66.157.173.166]) by imf05bis.bellsouth.net (InterMail vM.5.01.04.00 201-253-122-122-20010827) with SMTP id <20020103233110.WNDG17507.imf05bis.bellsouth.net@there> for ; Thu, 3 Jan 2002 18:31:10 -0500 Content-Type: text/plain; charset="iso-8859-1" From: Richard Rowell To: pgsql-sql@postgresql.org Subject: top? Date: Thu, 3 Jan 2002 17:27:59 -0600 X-Mailer: KMail [version 1.3.2] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20020103233110.WNDG17507.imf05bis.bellsouth.net@there> X-Archive-Number: 200201/26 X-Sequence-Number: 6117 Just wondering if there was a "TOP" equivilant in Postgres? IE select top 1 * from froo (only returns 1 row) TIA -- _________________________ Richard Rowell rwrowell@bellsouth.net If Java had true garbage collection, most programs would delete themselves upon execution. - Robert Sewell