Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s9o19-005Gtn-F3
	for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 15:36:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1s9o19-000dLU-FS
	for pgsql-general@arkaria.postgresql.org; Wed, 22 May 2024 15:36:39 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <htamfids@gmail.com>)
	id 1s9o19-000dLM-4x
	for pgsql-general@lists.postgresql.org; Wed, 22 May 2024 15:36:39 +0000
Received: from mail-lj1-x230.google.com ([2a00:1450:4864:20::230])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <htamfids@gmail.com>)
	id 1s9o16-001TMi-QZ
	for pgsql-general@lists.postgresql.org; Wed, 22 May 2024 15:36:37 +0000
Received: by mail-lj1-x230.google.com with SMTP id 38308e7fff4ca-2e576057c2bso98547381fa.1
        for <pgsql-general@lists.postgresql.org>; Wed, 22 May 2024 08:36:36 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1716392195; x=1716996995; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=R3uRrwUL9paTgZJR3vtSaTibSRqq5gZxt/7hOpNkSgc=;
        b=evbuM46G4Ub7B2T58Zc3zOd5fowef6sfh0WjTtqwkU5iiu/9aNXIuiB089MTP2YNZ6
         pOOIlTkNarPIQ7yn6PTTgvZMfV/ohccYOy12HfORh9+Hqur/mOEUAUaLoM+GA23FZxrZ
         4DA9SCLAnHbU0TTD7Fk2jrWTFX5PSWlLP63DOqKNPl1zj9yO9WKdWSHdb1YtVoSEOr7p
         5BjTjW8gnpUEohbV8ZrMWh4h+vLDWvmil9B15fPf03MshSPD1Hzvgz/xlrmtWdF4PHlI
         njQQl/qb2arWDzcdkawuZoiMabEqSwuuOwW/dPmG/myws81Hp4yfd+xDMoTOOsPnyr8P
         YXQQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1716392195; x=1716996995;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=R3uRrwUL9paTgZJR3vtSaTibSRqq5gZxt/7hOpNkSgc=;
        b=rwNulLt73EiPZpkn3Hkhr84WBtpNVk4XfADGDImwadwhPq33H6rjGocm5VBsF4t2z5
         PQKXcAXxX5xNdMGdyWb3mP1RAS+BjK1jvYk5HCJwOtF34oDJvxZF2aftoI261xW0RGaz
         XW3HNzsr1RnqcDb3yfxodcMYvKv1H9NeS8UsWQW2cBnA5UVM5qc+CIOhSMHhK77MrP92
         L9acmwtmIfpCQ6moy3C4B48Rx1JBZKimZTALC4i0yHp4Bp7P28QbwvpSQP0oQKGt7JAA
         sXQUjRDUq2t2mVb4XSJIVS8dJfFsajmUHuaXr7tpRrWsNa+wXDVtryYbA/HYFY/04aLr
         MSrg==
X-Forwarded-Encrypted: i=1; AJvYcCUYLS6dQeFcm6n16i+l3PekkI/o1RsFI4kvKV6ltdBS0Jt6gKn/63dtsYJlMiLc9JFq75QnBkgrXe6NUmPqIpM3AIQfz4XVw1/HtD9FR5ivYOdl
X-Gm-Message-State: AOJu0YwqcwgFZiMTDZQoLJiQ/GFBnRuzPXoHRQU6s6odc2VRc+0EJRks
	RKRiWXxb+DcMCnyEnNt/U4W8LanVa5Whl/UdxgEUOnVDVxZ8WNhQ9JrrUuwpSJeZLjp0YTdQzyN
	bOxo9S2PJ7GamaOjMMiiTjxH36F8=
X-Google-Smtp-Source: AGHT+IH16i0WTFBXiAKjY5k1h2aiQLKut7/oKIHI3RdzCDmmihcZBpoXJVC6ECqi2xPnOZ4yURj5R8lThjBZ4CLuk0U=
X-Received: by 2002:a2e:a36c:0:b0:2e8:5d2:5e9b with SMTP id
 38308e7fff4ca-2e949465c6fmr17293111fa.13.1716392194947; Wed, 22 May 2024
 08:36:34 -0700 (PDT)
MIME-Version: 1.0
References: <98fd5198e1fe4e162f1166fd0575844de8bb7714.camel@loonybin.net>
 <CAKAnmmLBxrQ0n4+BPb_xBQKrDRoiq4eSKdQYDbnmo7KTQVFuRg@mail.gmail.com> <CAMsGm5e5=YcjaUGQogkxMqrj9_beuSmVOrXTAuQPsBdmkbZPSA@mail.gmail.com>
In-Reply-To: <CAMsGm5e5=YcjaUGQogkxMqrj9_beuSmVOrXTAuQPsBdmkbZPSA@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Wed, 22 May 2024 11:35:58 -0400
Message-ID: <CAKAnmm+w4u8Yfdo4HmtEQQiBHsg0fJS0RWFqGBLVm5ibj=He2Q@mail.gmail.com>
Subject: Re: Finding "most recent" using daterange
To: Isaac Morland <isaac.morland@gmail.com>
Cc: Rob Foehl <rwf@loonybin.net>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000013426606190cb34f"
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/CAKAnmm%2Bw4u8Yfdo4HmtEQQiBHsg0fJS0RWFqGBLVm5ibj%3DHe2Q%40mail.gmail.com>
Precedence: bulk

--00000000000013426606190cb34f
Content-Type: text/plain; charset="UTF-8"

Oh, you are right - NULLS LAST, got my -infinity crossed with my infinity.
:)

Cheers,
Greg

--00000000000013426606190cb34f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Oh, you are right - NULLS LAST, got my -infinity crossed w=
ith my infinity. :)=C2=A0<div><br></div><div>Cheers,</div><div>Greg</div><d=
iv><br></div></div>

--00000000000013426606190cb34f--