From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Sebastien Flaesch <sebastien.flaesch@4js.com>,
        pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: Global setting for ORDER BY ... NULLS FIRST / LAST
In-reply-to: 
 <CAKFQuwY-dmsURUBHqjbrMN6vtezExhZYzHHUU_GSNgwWABisOQ@mail.gmail.com>
References: 
 <DBAP191MB12893AA929975291A05E2938B0029@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
 <CAKFQuwY-dmsURUBHqjbrMN6vtezExhZYzHHUU_GSNgwWABisOQ@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Tue, 01 Mar 2022 07:41:48 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2837299.1646146946.1@sss.pgh.pa.us>
Date: Tue, 01 Mar 2022 10:02:26 -0500
Message-ID: <2837300.1646146946@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2837300.1646146946%40sss.pgh.pa.us>
Precedence: bulk

"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