Re: Global setting for ORDER BY ... NULLS FIRST / LAST - Mailing list pgsql-sql

From Tom Lane
Subject Re: Global setting for ORDER BY ... NULLS FIRST / LAST
Date
Msg-id 2837300.1646146946@sss.pgh.pa.us
Whole thread Raw
In response to Re: Global setting for ORDER BY ... NULLS FIRST / LAST  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Global setting for ORDER BY ... NULLS FIRST / LAST
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Global setting for ORDER BY ... NULLS FIRST / LAST
Next
From: asalias mark
Date:
Subject: pg_stat_progress_copy not working as intended