>=> 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; ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
- [SQL] Getting row with id=max(id) Gerald Gutierrez
- Re: [SQL] Getting row with id=max(id) Tom Lane
- Re: [SQL] Getting row with id=max(id) jeff
- Re: [SQL] Getting row with id=max(id) Gerald Gutierrez
- [SQL] Getting row with id=max(id) Gerald Gutierrez
- [SQL] Getting row with id=max(id) Gerald Gutierrez