Re: Configure default for sorting of null-values?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Configure default for sorting of null-values?
Дата
Msg-id 9563.1283869975@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Configure default for sorting of null-values?  (Rob Gansevles <rgansevles@gmail.com>)
Ответы Re: Configure default for sorting of null-values?  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Configure default for sorting of null-values?
Следующее
От: Henk van Lingen
Дата:
Сообщение: Re: Forcing the right queryplan