Re: Configure default for sorting of null-values? - Mailing list pgsql-general

From Tom Lane
Subject Re: Configure default for sorting of null-values?
Date
Msg-id 9563.1283869975@sss.pgh.pa.us
Whole thread Raw
In response to Re: Configure default for sorting of null-values?  (Rob Gansevles <rgansevles@gmail.com>)
Responses Re: Configure default for sorting of null-values?  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Rob Gansevles <rgansevles@gmail.com> writes:
> Does anyone know if this is configurable?
> Or should I file a feature request?

It is not, and a feature request is probably going to go nowhere.
The reason configurability seems like a bad idea is that null sort
direction is wired into things like index contents.  If a user
were to flip the default null sort direction locally to his session,
then suddenly most of the indexes in the system would become unusable
to him.  No doubt there are things that could be done to ameliorate
that, but overall it's just not apparent that the cost/benefit ratio
is reasonable for such a change.

            regards, tom lane

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Configure default for sorting of null-values?
Next
From: Henk van Lingen
Date:
Subject: Re: Forcing the right queryplan