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

From Gary Stainburn
Subject [SQL] Most recent row
Date
Msg-id 201705050925.04194.gary.stainburn@ringways.co.uk
Whole thread Raw
Responses Re: [SQL] Most recent row  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: [SQL] Most recent row  (vinny <vinny@xs4all.nl>)
Re: [SQL] Most recent row  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: [SQL] Most recent row  ("David G. Johnston" <david.g.johnston@gmail.com>)
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 ..
;



pgsql-sql by date:

Previous
From: Hector Vass
Date:
Subject: Re: [SQL] Please advice on query optimization
Next
From: Karsten Hilbert
Date:
Subject: Re: [SQL] Most recent row