[SQL] Most recent row - Mailing list pgsql-sql

This question has been asked a few times, and Google returns a few different 
answers, but I am interested people's opinions and suggestions for the *best* 
wat to retrieve the most recent row from a table.

My case is:

create table people ( p_id  serial primary key,......
);

create table assessments ( p_id    int4 not null references people(p_id), as_timestamp    timestamp not null, ......
);

select p.*, (most recent) a.*  from people p, assessments a ..
;