Re: Getting row with id=max(id)

From: Gerald Gutierrez <gml1(at)coldresist(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Getting row with id=max(id)
Date: 2001-06-07 19:17:14
Message-ID: 5.1.0.14.0.20010607121617.02b925d0@coldresist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


>=> 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;

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Ivar Helbekkmo 2001-06-07 19:17:40 Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards
Previous Message Gerald Gutierrez 2001-06-07 19:13:50 Re: Getting row with id=max(id)