Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Дата
Msg-id 16585.1194448986@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Список pgsql-general
Simon Riggs <simon@2ndquadrant.com> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Temporary, In-memory Postgres DB?
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: md5() sorting