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
Список 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 по дате отправления: