Re: Finding "most recent" using daterange

From: Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: Rob Foehl <rwf(at)loonybin(dot)net>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Finding "most recent" using daterange
Date: 2024-05-22 16:13:12
Message-ID: CAMsGm5etC-cYWSq7sYF=OFEAcSrsKpKQD5=+9wB1V0SR5BkhOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 22 May 2024 at 11:36, Greg Sabino Mullane <htamfids(at)gmail(dot)com>
wrote:

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

NULLS LAST for lower bound, NULLS FIRST for upper bound.

The other way around if you were doing an ascending sort.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-05-22 16:35:51 search_path wildcard?
Previous Message Adrian Klaver 2024-05-22 16:05:24 Re: Restore of a reference database kills the auto analyze processing.