Re: ORDER BY DESC and NULLS LAST by default

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Loles <lolesft(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: ORDER BY DESC and NULLS LAST by default
Date: 2023-10-27 15:54:36
Message-ID: 02b23b24c9c76b5101b8ca784dfc9f52e65c68c4.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2023-10-27 at 16:16 +0200, Loles wrote:
> 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?

That is not simple.

You'd have to create new data types with new operators that do just the
opposite of the normal ones. I'd advise against it.

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-10-27 15:55:52 Re: Progress of ALTER TABLE on inheritance-partitioned table?
Previous Message Tom Lane 2023-10-27 14:45:02 Re: Rollback after "Connection timed out"?