Re: Extract only maximum date from column

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Extract only maximum date from column
Date: 2025-12-04 20:13:49
Message-ID: 47e11d37-37b-8341-a0c2-45f1b1b7ca9a@appl-ecosys.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 4 Dec 2025, Bryan Sayer wrote:

> I believe in general you need
>
> having c.next_contact = max(c.next_contact)
>
> (at least in ANSI SQL) Use having for after the join has occurred

Bryan,

Postgresql didn't like that regardless of where I inserted the `having'
stanza.

Thanks,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2025-12-04 20:18:14 Re: Extract only maximum date from column
Previous Message David G. Johnston 2025-12-04 20:03:35 Re: Extract only maximum date from column