Received: from coldresist.com (cr271446-a.rchmd1.bc.wave.home.com [24.113.128.171]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f57JAIE64921 for ; Thu, 7 Jun 2001 15:10:18 -0400 (EDT) (envelope-from gml1@coldresist.com) Received: from idyllic.coldresist.com ([192.168.0.7]) by coldresist.com (8.11.2/8.11.2) with ESMTP id f57JDVx19069 for ; Thu, 7 Jun 2001 12:13:31 -0700 Message-Id: <5.1.0.14.0.20010607121617.02b925d0@coldresist.com> X-Sender: gml1@coldresist.com X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Thu, 07 Jun 2001 12:17:14 -0700 To: pgsql-sql@postgresql.org From: Gerald Gutierrez Subject: Re: Getting row with id=max(id) In-Reply-To: <5.1.0.14.0.20010607120835.02bbbd60@coldresist.com> References: <5.1.0.14.0.20010607100000.02b8ae58@coldresist.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200106/115 X-Sequence-Number: 3335 >=> explain select id from mytable order by seed desc limit 1; Oops, a cut & paste mistake. That should be: explain select id from mytable order by id desc limit 1;