Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: ORDER BY DESC and NULLS LAST by default
Date
Msg-id 02b23b24c9c76b5101b8ca784dfc9f52e65c68c4.camel@cybertec.at
Whole thread Raw
In response to ORDER BY DESC and NULLS LAST by default  (Loles <lolesft@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rollback after "Connection timed out"?
Next
From: Laurenz Albe
Date:
Subject: Re: Progress of ALTER TABLE on inheritance-partitioned table?