Re: newbie question for return date

Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com> writes:
> Hey a suggestion, what if PG would support the negative limit as in
> select * from table limit -1 to mean limit it from the other end of
> list.....

You'd hardly want that, as it would necessarily be the slowest possible
way of retrieving the rows you're after.

Instead, reverse the sort order. For example

select * from table order by datecol desc limit 1;

regards, tom lane