Re: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST - Mailing list pgsql-novice

On 04/01/2019 08:09, David G. Johnston wrote:
> On Thursday, January 3, 2019, john snow <ofbizfanster@gmail.com
> <mailto:ofbizfanster@gmail.com>> wrote:
> 
>     is there a setting that is available for me to use to configure
>     Postgresql to order NULLS FIRST by default instead of NULLS LAST?
> 
> 
> No there is not and likely never will be as such an option introduces
> undesirable variability.


That, and the spec forbids it.

"If <null ordering> is not specified, then an implementation-defined
<null ordering> is implicit. The implementation-defined default for
<null ordering> shall not depend on the context outside of <sort
specification list>."
-- 
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support