Date: Fri, 5 Dec 2025 08:04:40 -0800 (PST)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Extract only maximum date from column [RESOLVED]
In-Reply-To: <1ad757c9-09d2-46fe-b3e0-2e09c85745dd@gelassene-pferde.biz>
Message-ID: <a74e4e5b-7b12-3962-f7e3-382e5c75882b@appl-ecosys.com>
References: <db81f086-e1a5-5798-f9bd-5bed5b1bc7f4@appl-ecosys.com> <1ad757c9-09d2-46fe-b3e0-2e09c85745dd@gelassene-pferde.biz>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Archived-At: <https://www.postgresql.org/message-id/a74e4e5b-7b12-3962-f7e3-382e5c75882b%40appl-ecosys.com>
Precedence: bulk

On Fri, 5 Dec 2025, Thiemo Kellner wrote:

> Am I missing something?

Thiemo,

Nope. I was the one missing something:

select p.person_nbr, p.company_nbr, max(c.next_contact)
from people as p
inner join contacts as c
       on p.person_nbr = c.person_nbr
where c.next_contact >= '2025-11-01'
group by p.person_nbr, p.company_nbr
order by p.person_nbr, p.company_nbr;

and,

  person_nbr | company_nbr |    max 
------------+-------------+------------
         226 |         736 | 2025-12-02
         367 |         396 | 2026-01-06
         464 |        2286 | 2025-11-05
         465 |         702 | 2025-11-17
         537 |         356 | 2025-11-03
         553 |         367 | 2025-12-02
         554 |         641 | 2025-12-02
...

Mea culpa!

Many thanks,

Rich