Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY DESC and NULLS LAST by default - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: ORDER BY DESC and NULLS LAST by default
Date
Msg-id C4B5BA76-C20C-4E85-AAD7-0FB1F472654B@jakobs.com
Whole thread Raw
In response to ORDER BY DESC and NULLS LAST by default  (Loles <lolesft@gmail.com>)
Responses Re: ORDER BY DESC and NULLS LAST by default
List pgsql-admin
Tree view
Actually, the behaviour isn't NULLS LAST, but NULLS GREATEST.

There is no setting for choosing NULLS SMALLEST.

If you choose NULLS LAST, they always appear at the end, regardless of ASC or DESC. NULLS FIRST does the opposite.

Regards,

Holger


Am 27. Oktober 2023 16:16:09 MESZ schrieb Loles <lolesft@gmail.com>:
Hi!

Can the server be configured so that the default ORDER BY option is DESC instead of ASC?

And to make it NULLS LAST instead of NULLS FIRST?

Happy weekend and Thank you very much!

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Progress of ALTER TABLE on inheritance-partitioned table?
Next
From: Loles
Date:
Subject: Re: ORDER BY DESC and NULLS LAST by default