Content-Type: multipart/alternative;
 boundary="------------fV233jazVZrAURsq7l8zNG1j"
Message-ID: <39ec51cc-906f-483d-8136-2bc4b7523dd8@gmail.com>
Date: Thu, 4 Dec 2025 15:24:40 -0500
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Extract only maximum date from column
To: pgsql-general@lists.postgresql.org
References: <db81f086-e1a5-5798-f9bd-5bed5b1bc7f4@appl-ecosys.com>
 <d0606565-1fad-419d-922c-b3e8f76495a6@gmail.com>
 <47e11d37-37b-8341-a0c2-45f1b1b7ca9a@appl-ecosys.com>
From: Bryan Sayer <blslists@gmail.com>
Content-Language: en-US
In-Reply-To: <47e11d37-37b-8341-a0c2-45f1b1b7ca9a@appl-ecosys.com>
Archived-At: <https://www.postgresql.org/message-id/39ec51cc-906f-483d-8136-2bc4b7523dd8%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------fV233jazVZrAURsq7l8zNG1j
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

You don't include the where clause, just the having clause after the 
group by.

At least that is what I remember. But it has been awhile.

*Bryan Sayer*
Retired Demographer/Statistician
/In a world in which you can be anything, *be kind*/
On 12/4/2025 3:13 PM, Rich Shepard wrote:
> 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
>
>
--------------fV233jazVZrAURsq7l8zNG1j
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>You don't include the where clause, just the having clause after
      the group by.</p>
    <p>At least that is what I remember. But it has been awhile.</p>
    <div class="moz-signature"><b>Bryan Sayer</b><br>
      Retired Demographer/Statistician<br>
      <i>In a world in which you can be anything, <b>be kind</b></i>
      <br>
    </div>
    <div class="moz-cite-prefix">On 12/4/2025 3:13 PM, Rich Shepard
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:47e11d37-37b-8341-a0c2-45f1b1b7ca9a@appl-ecosys.com">On
      Thu, 4 Dec 2025, Bryan Sayer wrote:
      <br>
      <br>
      <blockquote type="cite">I believe in general you need
        <br>
        <br>
        having c.next_contact = max(c.next_contact)
        <br>
        <br>
        (at least in ANSI SQL) Use having for after the join has
        occurred
        <br>
      </blockquote>
      <br>
      Bryan,
      <br>
      <br>
      Postgresql didn't like that regardless of where I inserted the
      `having'
      <br>
      stanza.
      <br>
      <br>
      Thanks,
      <br>
      <br>
      Rich
      <br>
      <br>
      <br>
    </blockquote>
  </body>
</html>

--------------fV233jazVZrAURsq7l8zNG1j--


xE8KEEOXXSimf_oxEyp6YfJDju-nMlw>
    <xmx:kPp3aXieZorYoSmSzp6ccXGxUoGUhrVzIdFi9tClV0l0rKtv7zgcOg>
    <xmx:kPp3aZRSsFVOBMyz28uHHJMPbqTouHJ3vSpw1KFDcl-o-vEeDYQIJg>
    <xmx:kPp3af0bHyYg1AjnJqK3hNWp1JYWHuTZkGczdTflLmBYyd6QzpPEm66B>
Feedback-ID: i1549424b:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA for
 <pgsql-general@lists.postgresql.org>; Mon,
 26 Jan 2026 18:36:48 -0500 (EST)
Received: from LAPTOPKIAGPN6L (laptop-kiagpn6l.tail35a169.ts.net [100.78.0.90])
	by ginkgo.ccn.me (OpenSMTPD) with ESMTPSA id b6ed3f71 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO) auth=yes user=mailimap
	for <pgsql-general@lists.postgresql.org>;
	Mon, 26 Jan 2026 23:36:48 +0000 (UTC)
From: "Chris Nestrud" <ccn@chrisnestrud.com>
To: <pgsql-general@lists.postgresql.org>
Subject: Not read: The best way to solve a problem
Date: Mon, 26 Jan 2026 17:36:29 -0600
Message-ID: <3e75e01dc8f1c$a3974b90$eac5e2b0$@chrisnestrud.com>
MIME-Version: 1.0
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"
X-Mailer: Microsoft Outlook 16.0
Thread-Index: AQGI7ng92cdvGtoZZv9fiRoAq6UMSAMxGqsZAbbhYPe15RvpNQ==
X-MS-TNEF-Correlator: 000000003DA5E25F0ED0F54CAD247724A554C1290700C3B68E10F77511CEB4CD00AA00BBB6E6000000000005000074C2F6CE2BF94D43B755239D29D9087600000000D83C0000
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/3e75e01dc8f1c%24a3974b90%24eac5e2b0%24%40chrisnestrud.com>
Precedence: bulk

eJ8+IjAXAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAFwAAAFJFUE9SVC5J
UE0uTm90ZS5JUE5OUk4AtwYBCoABAAkAAAAzNDAzMDAwMACKAQEDkAYAUAMAABwAAAALACkAAAAA
AEAAMgAQhh5dHI/cAR4ASQABAAAAJAAAAFJlOiBUaGUgYmVzdCB3YXkgdG8gc29sdmUgYSBwcm9i
bGVtAAIBTAABAAAAZgAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABgE4AaQBrAG8AbABhAGkAIABM
AHUAcwBhAG4AAABTAE0AVABQAAAAbgBpAGsAbwBsAGEAaQBAAGwAdQBzAGEAbgAuAGkAZAAuAGEA
dQAAAAAAHgBNAAEAAAAOAAAATmlrb2xhaSBMdXNhbgAAAEAATgAAMcVm9NvVAUAAVQCAiUlz9NvV
AR4AcAABAAAAIAAAAFRoZSBiZXN0IHdheSB0byBzb2x2ZSBhIHByb2JsZW0AAgFxAAEAAAAlAAAA
AQGI7ng92cdvGtoZZv9fiRoAq6UMSAMxGqsZAbbhYPe15RvpNQAAAB4AcgABAAAAAQAAAAAAAAAe
AHMAAQAAAAEAAAAAAAAAHgB0AAEAAAAjAAAAcGdzcWwtZ2VuZXJhbEBsaXN0cy5wb3N0Z3Jlc3Fs
Lm9yZwAACwAIDAAAAAALAAEOAQAAAAMAFA4BAAAAHgABEAEAAAAZAAAATWVzc2FnZSB3YXMgbm90
IHJlYWQgYnk6AAAAAAMA3j/p/QAACwAfDgEAAAACAfgPAQAAABAAAABQ4iGv/tDASqDI2b8UA9wJ
AgH6DwEAAAAQAAAAPaXiXw7Q9UytJHckpVTBKQMA/g8FAAAAAwANNP0/rQ4DAA80/T+tDgIBFDQB
AAAAEAAAAOkv63WWUESGg7h95SKqSUgeAPo/AQAAAAcAAABnaW5rZ28AAAIB4mUBAAAAFAAAAJ81
f58p+rhKs1G37xTRMicAC3K2AgHjZQEAAAAVAAAAFJ81f58p+rhKs1G37xTRMicAC3K2AAAAAgF/
AAEAAACNAAAAMDAwMDAwMDAzREE1RTI1RjBFRDBGNTRDQUQyNDc3MjRBNTU0QzEyOTA3MDBDM0I2
OEUxMEY3NzUxMUNFQjRDRDAwQUEwMEJCQjZFNjAwMDAwMDAwMDAwNTAwMDA3NEMyRjZDRTJCRjk0
RDQzQjc1NTIzOUQyOUQ5MDg3NjAwMDAwMDAwRDgzQzAwMDAAAAAAzMQ=