Re: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST
Дата
Msg-id CAKFQuwYMa32Gx2Gcj7pMbjDLEkpTCe0VXAsdp+JWLhWA=1mXuw@mail.gmail.com
обсуждение исходный текст
Ответ на RE: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST  ("Vianello, Daniel A" <Daniel.Vianello@charter.com>)
Список pgsql-novice
Дерево обсуждения
On Friday, January 4, 2019, Vianello, Daniel A <Daniel.Vianello@charter.com> wrote:

 Or you could create views to do complex sorting on a table and have users use the view instead of the table, but that is still extra development per table, not your apparently desired global change of behavior.

Most views should not specify a sort order.  Client-sent queries should append order by according to their need in presenting the data to the user-side of the system.

David J. 

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

Предыдущее
От: "Vianello, Daniel A"
Дата:
Сообщение: RE: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST
Следующее
От: Stephen Froehlich
Дата:
Сообщение: pg_upgrade on new boot / Where to mount filesystems for tablespaces /other zfs questions