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

From Rob Sargent
Subject Re: Selecting table row with latest date
Date
Msg-id 301C48DC-63E1-45CA-AA2E-E3F7FD13019B@gmail.com
Whole thread Raw
In response to Re: Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general

> On Aug 19, 2021, at 10:59 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>
> On Thu, 19 Aug 2021, Rob Sargent wrote:
>
>> Yeah, but my quibble is the the table you described up-thread. Your
>> contact table contains next_contact? I think that column should be
>> normalized out.
>
> Rob,
>
> Why should I have a separate table with one column: next_contact? The
> next_contact date is associated with a person and the date that person was
> contacted.
>
> Rich

sorry, wasn’t clear: person_nbr, next_contact
On the premise that there can only be one next date.

>
>
>
>




pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Selecting table row with latest date
Next
From: Rich Shepard
Date:
Subject: Re: Selecting table row with latest date