Date: Fri, 5 May 2017 11:35:05 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Gary Stainburn <gary.stainburn@ringways.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Most recent row
Message-ID: <20170505093505.GA5611@depesz.com>
Reply-To: depesz@depesz.com
References: <201705050925.04194.gary.stainburn@ringways.co.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <201705050925.04194.gary.stainburn@ringways.co.uk>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On Fri, May 05, 2017 at 09:25:04AM +0100, Gary Stainburn wrote:
> 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
>   ..
> ;

How many rows are in people? How many in assessments? Do you really want
data on all people? Or just some?

Best regards,

depesz


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql