Horton
Menu

Re: Finding "most recent" using daterange

Isaac Morland <isaac.morland@gmail.com>

View thread
From: Isaac Morland <isaac.morland@gmail.com>
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Rob Foehl <rwf@loonybin.net>, pgsql-general@lists.postgresql.org
Date: 2024-05-22T16:13:12Z
Lists: pgsql-general 
On Wed, 22 May 2024 at 11:36, Greg Sabino Mullane <htamfids@gmail.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.