Re: Select most recent record?

"Marc Sherman" <msherman@projectile.ca> writes:
> I'd like to select the newest (max(timestamp)) row for each id,
> before a given cutoff date; is this possible?

select * from log order by timestamp desc limit 1;
        regards, tom lane