Re: Selecting table row with latest date [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: Selecting table row with latest date [RESOLVED]
Date
Msg-id alpine.LNX.2.20.2108191451030.15165@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Selecting table row with latest date [RESOLVED]  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Selecting table row with latest date [RESOLVED]  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On Thu, 19 Aug 2021, David G. Johnston wrote:

> I thought you said (p.person_nbr, c.contact_date) is already unique?

David,

Yes, that's the PK for the contacts table. I'm still unsure what needs to be
explicitly included in a query. Quite often I leave out a column and
postgres tells me it needs to be included in order by or group by.

Rich



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Selecting table row with latest date [RESOLVED]
Next
From: "David G. Johnston"
Date:
Subject: Re: Selecting table row with latest date [RESOLVED]