Re: ORDER BY DESC and NULLS LAST by default

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: ORDER BY DESC and NULLS LAST by default
Date: 2023-10-27 16:25:44
Message-ID: C4B5BA76-C20C-4E85-AAD7-0FB1F472654B@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)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!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Loles 2023-10-27 17:55:19 Re: ORDER BY DESC and NULLS LAST by default
Previous Message Laurenz Albe 2023-10-27 15:55:52 Re: Progress of ALTER TABLE on inheritance-partitioned table?