Home > mailing lists

Re: Finding "most recent" using daterange - Mailing list pgsql-general

From	Isaac Morland
Subject	Re: Finding "most recent" using daterange
Date	May 22 19:13:12
Msg-id	CAMsGm5etC-cYWSq7sYF=OFEAcSrsKpKQD5=+9wB1V0SR5BkhOg@mail.gmail.com Whole thread Raw
In response to	Re: Finding "most recent" using daterange (Greg Sabino Mullane <htamfids@gmail.com>)
List	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.

From: Adrian Klaver
Date: 22 May, 19:05:24
Subject: Re: Restore of a reference database kills the auto analyze processing.

From: Ron Johnson
Date: 22 May, 19:35:51
Subject: search_path wildcard?