From: | vinny <vinny(at)xs4all(dot)nl> |
---|---|
To: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-sql-owner(at)postgresql(dot)org |
Subject: | Re: Most recent row |
Date: | 2017-05-05 08:50:36 |
Message-ID: | 7690a8d6f9fd1ce96b89f97425d8ae33@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On 2017-05-05 10:25, 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
> ..
> ;
It depends on what you mean by 'most recent'. Do you mean "the row I
just inserted" or "the row with a date closest to now()" or perhaps some
other definition?
From | Date | Subject | |
---|---|---|---|
Next Message | Gary Stainburn | 2017-05-05 09:13:07 | Re: Most recent row |
Previous Message | Karsten Hilbert | 2017-05-05 08:32:21 | Re: Most recent row |