Re: configure postgtresql to order NULLS FIRST instead of the default NULLS LAST
Vik Fearing <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Organization | 2ndQuadrant France |
| Message-ID | <[email protected]> |
On 04/01/2019 08:09, David G. Johnston wrote: > On Thursday, January 3, 2019, john snow <[email protected] > <mailto:[email protected]>> 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