Simon Riggs <simon@xxxxxxxxxxxxxxx> writes:
> Perhaps we can have a parameter?
> default_null_sorting = 'last' # may alternatively be set to 'first'
Not unless it's locked down at initdb time. Otherwise flipping the
value bars you from using every existing index ... including those
on the system catalogs ... which were made with the other setting.
I put this in the same category as altering the identifier case-folding
rules. Yeah, it'd be great to be all things to all people, but the
implementation pain and risk of breakage of existing applications
isn't worth it.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
