- Configurable:
set default_null_order = [NULLS_FIRST | NULLS_LAST | NULLS_FIRST_ON_ASC_LAST_ON_DESC | NULLS_LAST_ON_ASC_FIRST_ON_DESC]
Related
Standard Feature-IDs
T611, "Elementary OLAP operations":
nulls last,nulls first
Normative References
The implementation defined item ID133, "The implicit null ordering when null ordering is not specified" is defined in ISO/IEC 9075-2:2023. The standard edition of 1989 did explicitly defined the null ordering as "implementator defined" but also required null values to be treated either greater or smaller than non-null values. This remained standard until 2003, when nulls first | last was introduced. Since then, the <null ordering> is implementation defined and may depend on the presence of asc and desc but must not depend on context outside the order by clause.
