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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Global setting for ORDER BY ... NULLS FIRST / LAST
Дата
Msg-id 2837300.1646146946@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Global setting for ORDER BY ... NULLS FIRST / LAST  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Global setting for ORDER BY ... NULLS FIRST / LAST  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
Список pgsql-sql
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Tue, Mar 1, 2022 at 7:16 AM Sebastien Flaesch <sebastien.flaesch@4js.com>
> wrote:
>> Is there a global PostgreSQL server setting or SQL session parameter that
>> defines the default for   ORDER BY ... NULLS FIRST / LAST ?

> IMO, not enough of a benefit to spend development time on.  Having global
> configuration like this is something that should be, and in general is,
> avoided.  Most of the exceptions to this have been regretted.

Yeah.  We have generally found that settings that change query semantics
are a net evil.

            regards, tom lane



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Global setting for ORDER BY ... NULLS FIRST / LAST
Следующее
От: asalias mark
Дата:
Сообщение: pg_stat_progress_copy not working as intended