Global setting for ORDER BY ... NULLS FIRST / LAST

Поиск
Список
Период
Сортировка
От Sebastien Flaesch
Тема Global setting for ORDER BY ... NULLS FIRST / LAST
Дата
Msg-id DBAP191MB12893AA929975291A05E2938B0029@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: Global setting for ORDER BY ... NULLS FIRST / LAST  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-sql
Дерево обсуждения
Hello!

Is there a global PostgreSQL server setting or SQL session parameter that defines the default for   ORDER BY ... NULLS FIRST / LAST ?

Assuming that it would be something like "NULL is lowest value, or NULL is highest value", to get the expected behavior when using ASC/DESC options of ORDER BY ...

That would help to migrate to PostgreSQL for DB engines having a different default behavior regarding NULL sorting.

Thanks!
Seb

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

Предыдущее
От: Jian He
Дата:
Сообщение: NORM(NO ORM) transform two one-many relationships into a single json.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Global setting for ORDER BY ... NULLS FIRST / LAST