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!
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
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!