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