Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPO0v-0007kC-0s for pgsql-sql@arkaria.postgresql.org; Wed, 02 Mar 2022 12:23:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nPO0t-00016m-Qh for pgsql-sql@arkaria.postgresql.org; Wed, 02 Mar 2022 12:23:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPO0t-00015w-G5 for pgsql-sql@lists.postgresql.org; Wed, 02 Mar 2022 12:23:27 +0000 Received: from mx0d-001a4c01.pphosted.com ([67.231.151.23]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPO0l-00021X-5N for pgsql-sql@lists.postgresql.org; Wed, 02 Mar 2022 12:23:21 +0000 Received: from pps.filterd (m0210020.ppops.net [127.0.0.1]) by mx0c-001a4c01.pphosted.com (8.16.1.2/8.16.1.2) with ESMTP id 2225Lnld029110; Wed, 2 Mar 2022 07:23:14 -0500 Authentication-Results: ppops.net; spf=pass smtp.mailfrom=sebastien.flaesch@4js.com; dkim=pass header.s=selector2-ourvolaris-onmicrosoft-com header.d=ourvolaris.onmicrosoft.com Received: from mail.ourvolaris.com ([206.25.40.41]) by mx0c-001a4c01.pphosted.com (PPS) with ESMTPS id 3ehekr5xsf-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT); Wed, 02 Mar 2022 07:23:13 -0500 Received: from VOL-SLO-EXCH1.vgnet.volgrp.com (172.23.0.51) by VOL-SLO-EXCH3.vgnet.volgrp.com (172.23.0.53) with Microsoft SMTP Server (TLS) id 15.0.1497.28; Wed, 2 Mar 2022 12:23:10 +0000 Received: from EUR02-HE1-obe.outbound.protection.outlook.com (104.47.5.55) by VOL-SLO-EXCH1.vgnet.volgrp.com (172.23.0.51) with Microsoft SMTP Server (TLS) id 15.0.1497.28 via Frontend Transport; Wed, 2 Mar 2022 12:23:09 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=nfoLj+wmowOWFW6hC83tW/7hQR/+P+a5p84F3OyQO+49ANjEsvpM4Ft9D+RHOfzXBGlu0LbTk7jXn8RshpUCJ/xTySQ16YXHRIi3zReqJ0btdw4JYIsfbGbBKu8jaO5jAmj/0J2Fvn8I5M1zysgilB5Wis5FJM10A+GcOb0ujxsy5URfCXxsBTYnqr0LSZqR/z14OBAxbWU0fzf0T2RxTGGMa1LOXOZW2MZwbiaWEoWbTsGtSwhmArpB0jR848tUNe7vKV7CcfWBFaJopjowTf0DyZf+ivhJzWYPMtygHBPdp7rzsVG5LM6VGgWEGNBPB1atrXcO3vgs7Tso0+h0rw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=yv2nx+gNatBiHhU3lhFm6Qfr794VJnfTDk6DoREYGT4=; b=iECjMbPglyDyNz1Uyo8KHfJznkBEnQ9Vp/R4XXvHI/NuhWPerrNFXsALDlXDR+25LFdPJ63ZmBKZu0o/PL2z57mz3a+V7c5V5b9bXKHmJ6U/QnaP4TCN46bqph+lgpkCLXxfND/WYo32jCzqzT+ZBL9i+dXy++1um30CE3oV4MdQrpgJUj4npWjidsuJchx1XLHxB8nG68+xQE4HMrVZhiwPcC4cW3xBmAttPphJQ3BxQcUOyC2PrNQOE/5SU0/tT1t1/MLGPP7jr/mJyWZJxdNjuCX2AXdQw7mWlLtQvT/ck7ynf4xDf0+jHFHHMTXG6e2hJsP3j9wtU1g8p5gH9w== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=4js.com; dmarc=pass action=none header.from=4js.com; dkim=pass header.d=4js.com; arc=none Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM (2603:10a6:10:1c9::19) by PAXP191MB1855.EURP191.PROD.OUTLOOK.COM (2603:10a6:102:1bd::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5038.14; Wed, 2 Mar 2022 12:23:08 +0000 Received: from DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::a533:756:799f:8c50]) by DBAP191MB1289.EURP191.PROD.OUTLOOK.COM ([fe80::a533:756:799f:8c50%3]) with mapi id 15.20.5017.027; Wed, 2 Mar 2022 12:23:08 +0000 From: Sebastien Flaesch To: Tom Lane , "David G. Johnston" CC: pgsql-sql Subject: Re: Global setting for ORDER BY ... NULLS FIRST / LAST Thread-Topic: Global setting for ORDER BY ... NULLS FIRST / LAST Thread-Index: AQHYLXZY9LzBDFcQmk6ziL7TBSLbQ6yqmgkAgAAFxACAAWW80Q== Date: Wed, 2 Mar 2022 12:23:08 +0000 Message-ID: References: <2837300.1646146946@sss.pgh.pa.us> In-Reply-To: <2837300.1646146946@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: suggested_attachment_session_id: 4c22ce22-b85c-b492-fc02-37f21e08e9ce x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 585b7253-9479-4b83-2c62-08d9fc47693a x-ms-traffictypediagnostic: PAXP191MB1855:EE_ x-microsoft-antispam-prvs: x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 5ggN1zy2KrTVbTVNhccN+fwH8zG2JW7smVzEHYMbJ7m4j2gUNmQXSYrEhge2S9zphGcf6P1D2MBqTHzxHDOrA8Gcq6noe46jnpMcTgjzvv5t5unXDnIOW2tipY3POEJoRDBUklG75lXvlZ2t6JeinZA2XymY5J8uo84Ck90cBcMWirYmbzrmxyssvuuQhKVMnJZpf4q4BapQhtMwrupZ76vw49foZddOg4TtMChEsVacLkSToPAtFtmskvBzsnMsJMedqunlo6Ko7fsQJV6kj5r5p+3Tktv1eznOSPmhwnSnKCm4mVb3OOPtVelOpKvMcCHQxKCZvSNALSMPswTSp8ftrmS6ed+ZtRs38AUqsjNtPZVs05VKBA53pGluJ7Z/Z+Qwzu8Z1xI/09Ho+Ai3I5sihLOFKTlwtSauqdsIMoQjXTYmgiMdhQjQ5eUhN3nAWNBPaIXumA1j2hcHe8NdkuGUcECWsl8pEIAb2XabRVsjIIsV4cXWvEcNa3pQ2x/hfxzbzFuB/kszNQs01eYJ4iiHIH7WN+ncDd7veY4gTXNKY+4dyjjlSJL1yw3M9KL4zcZl+Npi3kUBmAzpnYxOIJHRmG4pTpy10o3KffQBuNXH+bvb6yhhWE4V1bT6qNd3QMWVcEE5DQ6Zt2G5cyDbNnKxVTSz8DvH8UwSI7YwlbqwxhxUWqMhHsvlSz5HW1LWTZLLWBgG2+WWt/sFUtijSw== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DBAP191MB1289.EURP191.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230001)(4636009)(366004)(9686003)(6506007)(7696005)(71200400001)(53546011)(55016003)(110136005)(508600001)(33656002)(64756008)(66446008)(8676002)(316002)(83380400001)(76116006)(91956017)(66946007)(66476007)(66556008)(4326008)(19627405001)(122000001)(5660300002)(8936002)(38070700005)(2906002)(86362001)(52536014)(186003)(26005)(44832011)(38100700002);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?ypYWVBT3LJNWOdNXRu5xIJE67Jk45oDT/8nA4pnYQi02h8U8LhQsG6lHcjyK?= =?us-ascii?Q?OGPbYwrwQ6al9W2qUsaBxxcS5Gjjupn+AgTTXw3HMIwzHA169EL6r82hn0dL?= =?us-ascii?Q?ZlDS4iWfP2aE6WDvy38aVZqtLRuHOY4ioFx8ceZRpsovZdkuaxUOASs7ZwGD?= =?us-ascii?Q?26lCHKJLnSRPuvyD+doKhCMOGPT2oM9Dw1tFVMwk3+N6MK59ZPsyPwIPivCH?= =?us-ascii?Q?QHgxU5e6XsiYzxWoLpjy/Fz1opoAA8jqr9o4SuEvwmWmri8NF4VPkIf3wHMH?= =?us-ascii?Q?Rwwi38cYLO1l8AKSQPva34MzaM1uxU51U2QBm5qE1RMbQLA7eplaBF4Kzmt9?= =?us-ascii?Q?FglJQNEWB2OF5QlcKB4gOmBIKpWcjEzmHO4N1wG8szNmCjKjl/lPM+VvWy3X?= =?us-ascii?Q?++PH7t+hGwzac3tAiQy30ZljTSI9oPjEFuZGkcpd/GcEta+1FIQxlRA0X7TZ?= =?us-ascii?Q?yu2e+iXGtb78TbaGDVrd6GPkIVi83Y+iNkppaRvF8sAD+DoTFLOX/xPaNCeK?= =?us-ascii?Q?iAd3762ke/lW0S88o2lmyr5TEb3sIOIpB8czajLsxDo98gDHnSp9h9c+54Ra?= =?us-ascii?Q?TIjcw477b5HsNZfEvA2DOygtcsU1Opyh0yOzj/c6cV6x2F1r8t04ZQf/xkBi?= =?us-ascii?Q?XrdcxpZWq5Zcn9zCtoqDimhiTl1mJ8DeQXBNvDcm7bk0+LMaB84F3krQeTAb?= =?us-ascii?Q?vEiNb7VeiwEun0xetFyW41SaRSLQ1Ga0HyyjvEb8a/IBhD4/o8bekkZyn4Ej?= =?us-ascii?Q?ppLRTjL0h0z3DddpSj3dLJD8nyKpn7wiRdApQpME5lR/HApzYGE4HZNa+3/Z?= =?us-ascii?Q?tANMtBKYFo596EdI8hBT4u1MMOvKLibw9cDgTEh1kZT/ea3YI/lGGnNA5+mg?= =?us-ascii?Q?Q5ojCYJtOQLa5piEkuwPF1MLVOHGaklYdBGfWmcUzMjZvAX52hFjw3TYkYlV?= =?us-ascii?Q?WxFnpb/CZtndPV3TL83RfWP+ii1ZitJ545wtXyKKUabWnmctQTfLWbCvwklS?= =?us-ascii?Q?9HQ11Aiu4CMUSecOc1iAEw/gVUbvTDya6KgjcyhifSMECwrO0r/Cci260V5U?= =?us-ascii?Q?wnAeKl/lI51ZXiJeLw6M3YzXP0JFBUMfsuAKtcPBk4i1S803a/MvJaNYLjp6?= =?us-ascii?Q?7/eGyGnvWPZJjvyP2Wnh4MLHFE0mt6/zzfjK6pEVdYD8xY5OGZhQ1dmwZrlr?= =?us-ascii?Q?fDNbtYZ2bMfgyor17vUk6hY+DvDt6IU+/WS1yhV1V/jewQqtJCHTYmqX/Ixk?= =?us-ascii?Q?8ZuFNiZDnzPOCX1fBRESeauW+MedH/KZHDSWFanqKDEgbHNlFE85Ajf61DYe?= =?us-ascii?Q?Q7bLn7VKRwJhUQKs39OO3cFVwft10O8Lw9wiKbUqFMptJWkfEqcXeO7jamxx?= =?us-ascii?Q?ul+3PB+LhQONPBrlrOEV7s1u9nLeXcnWQf2CnL1inVImEKryduI5UrJGaH6r?= =?us-ascii?Q?22Q61xNu8HhgYakye52s8mc5GY9pHXkBvHCRTkht13jplmOjtucJRnZAEVeV?= =?us-ascii?Q?NxkIeWAzLVeskErqQfNwd5jbb2Tlld8Az+jXEZbnl9vcb5vdt9gvl2U3Gpsm?= =?us-ascii?Q?lj0XcGBsRyMqkLkp+m0Qc6e9M6hX7BPE/RWSO5EaraQbewieAk3Y8ad8ln+K?= =?us-ascii?Q?vv7dHML2c6P9nNap4myp5oizXwscPbREBg3J8qnEahkl2zFQOWIuZm4V1Rb4?= =?us-ascii?Q?/G1EvQ=3D=3D?= Content-Type: multipart/alternative; boundary="_000_DBAP191MB12892A80916C970A1B8AE5A5B0039DBAP191MB1289EURP_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DBAP191MB1289.EURP191.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 585b7253-9479-4b83-2c62-08d9fc47693a X-MS-Exchange-CrossTenant-originalarrivaltime: 02 Mar 2022 12:23:08.7152 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 75c696ec-5bfb-4892-9a0c-9187a9061cd6 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: FHBPTKivFzuwpfRNFA397zzDHQQQhEexAiwJMWezNBbzhL+Y7qg2Oo1NqlGDBofLBxf2EKulXeWdM3AKAajBarvUR1CL7jOae9koEojdGbU= X-MS-Exchange-Transport-CrossTenantHeadersStamped: PAXP191MB1855 X-OriginatorOrg: 4js.com X-C2ProcessedOrg: 2f0c79df-a80b-40c2-9362-4c5fa2dae201 X-Proofpoint-GUID: Y64iklroIuCuntI2bAZhxCPi-sN9GWps X-Proofpoint-ORIG-GUID: Y64iklroIuCuntI2bAZhxCPi-sN9GWps X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.205,Aquarius:18.0.816,Hydra:6.0.425,FMLib:17.11.64.514 definitions=2022-03-02_06,2022-02-26_01,2022-02-23_01 X-Proofpoint-Spam-Reason: safe List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DBAP191MB12892A80916C970A1B8AE5A5B0039DBAP191MB1289EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable OK I understand. Seb ________________________________ From: Tom Lane Sent: Tuesday, March 1, 2022 4:02 PM To: David G. Johnston Cc: Sebastien Flaesch ; pgsql-sql Subject: Re: Global setting for ORDER BY ... NULLS FIRST / LAST EXTERNAL: Do not click links or open attachments if you do not recognize th= e sender. "David G. Johnston" writes: > On Tue, Mar 1, 2022 at 7:16 AM Sebastien Flaesch > wrote: >> Is there a global PostgreSQL server setting or SQL session parameter tha= t >> 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 --_000_DBAP191MB12892A80916C970A1B8AE5A5B0039DBAP191MB1289EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
OK I understand.
Seb
From: Tom Lane <tgl@sss.= pgh.pa.us>
Sent: Tuesday, March 1, 2022 4:02 PM
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Sebastien Flaesch <sebastien.flaesch@4js.com>; pgsql-sql &= lt;pgsql-sql@lists.postgresql.org>
Subject: Re: Global setting for ORDER BY ... NULLS FIRST / LAST
 
EXTERNAL: Do not click links or open attachments i= f you do not recognize the sender.

"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 paramet= er that
>> defines the default for   ORDER BY ... NULLS FIRST / LAS= T ?

> IMO, not enough of a benefit to spend development time on.  Havin= g 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 semanti= cs
are a net evil.

            &nb= sp;           regards, to= m lane
--_000_DBAP191MB12892A80916C970A1B8AE5A5B0039DBAP191MB1289EURP_--