Re: ORDER BY DESC and NULLS LAST by default

[Loles <lolesft@xxxxxxxxx>]

I was really wondering if, just like you can disable autocommit mode in PostgreSQL, if you could configure some parameter so that ORDER BY, by default, would order DESC instead of ASC.

I suppose there is always the option of downloading the source code, changing it, compiling and installing but it will undoubtedly be easier to use ORDER BY DESC in all queries ;)

Thank you very much for all your contributions to my question.

Happy weekend!

El vie, 27 oct 2023 a las 18:25, Holger Jakobs (<holger@xxxxxxxxxx>) escribió:

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@xxxxxxxxx>:

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!