Re: Selecting table row with latest date

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Selecting table row with latest date
Дата
Msg-id 301C48DC-63E1-45CA-AA2E-E3F7FD13019B@gmail.com
обсуждение исходный текст
Ответ на Re: Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Selecting table row with latest date  (Rich Shepard <rshepard@appl-ecosys.com>)
Список 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 по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Selecting table row with latest date
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Selecting table row with latest date