Postgres Pro
Downloads
Home   >   mailing lists

Selecting table row with latest date - Mailing list pgsql-general

From Rich Shepard
Subject Selecting table row with latest date
Date
Msg-id alpine.LNX.2.20.2108190730510.15165@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Selecting table row with latest date  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
Re: Selecting table row with latest date  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Selecting table row with latest date  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
I have a table of contacts (PK is the person_nbr and contact_date) and I
want to select only the row with the latest (most recent) contact_date. The
Comparison Date/Time sections in the postgres 12 doc doesn't appear to have
what I want, and when I try to use the max() aggregate function it throws an
error.

Please point me to the proper place in the docs where I can learn how to do
this.

Rich

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to detach a database
Next
From: "David G. Johnston"
Date:
Subject: Re: Selecting table row with latest date