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 1nP3Iv-0005Nf-Q6 for pgsql-sql@arkaria.postgresql.org; Tue, 01 Mar 2022 14:16:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nP3Iu-0006KG-KJ for pgsql-sql@arkaria.postgresql.org; Tue, 01 Mar 2022 14:16:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nP3Iu-0006K6-6d for pgsql-sql@lists.postgresql.org; Tue, 01 Mar 2022 14:16:40 +0000 Received: from mx0d-001a4c01.pphosted.com ([67.231.151.23] helo=mx0c-001a4c01.pphosted.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nP3Il-00063Q-I7 for pgsql-sql@lists.postgresql.org; Tue, 01 Mar 2022 14:16:33 +0000 Received: from pps.filterd (m0075702.ppops.net [127.0.0.1]) by mx0d-001a4c01.pphosted.com (8.16.1.2/8.16.1.2) with ESMTP id 2214MECu018117 for ; Tue, 1 Mar 2022 09:16:28 -0500 Authentication-Results: ppops.net; spf=pass smtp.mailfrom=sebastien.flaesch@4js.com; dkim=pass header.d=ourvolaris.onmicrosoft.com header.s=selector2-ourvolaris-onmicrosoft-com Received: from mail.ourvolaris.com ([206.25.40.41]) by mx0d-001a4c01.pphosted.com (PPS) with ESMTPS id 3eh2cs3j9v-6 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT) for ; Tue, 01 Mar 2022 09:16:28 -0500 Received: from VOL-SLO-EXCH2.vgnet.volgrp.com (172.23.0.52) by VOL-SLO-EXCH3.vgnet.volgrp.com (172.23.0.53) with Microsoft SMTP Server (TLS) id 15.0.1497.28; Tue, 1 Mar 2022 14:16:24 +0000 Received: from EUR05-DB8-obe.outbound.protection.outlook.com (104.47.17.108) by VOL-SLO-EXCH2.vgnet.volgrp.com (172.23.0.52) with Microsoft SMTP Server (TLS) id 15.0.1497.28 via Frontend Transport; Tue, 1 Mar 2022 14:16:24 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=EwHOqxs+QUEI6tu+SMBSwDHmyGsCvxyGFJzf0MjSpeVmlORRPJTX/41SboE+IfLPMBkwQwaFOPOt1Lxya9WXXqE54ux8nMSjlklW0cRtUQGBXyMDGllXnwIP2V6q7vUFJYeokGIT+/mTmyx7g3O+XSGn4IPbUNmgTV4cAUBMI1UbEmrhVojoqJ/ITWdahl7NPScHc8sAj6aR2tHI2ksfzqbTmKMHEnACNyDx1oT8XmavOj4vqanvnAM0Cc6psD0Iw/kIjkZqKkOAuthjfRpYGA5wMRVtZ4CSIscthpK5VR0RcEs7IxZ/dyW8VLe04/yS4ojFXx4T7aiIHSZf6j58tg== 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=xD2WHg8vH3GDmcUPO60LyskitjGs0MRGCNRHga+hpGc=; b=dJqFMaG3C6nz2eXS7n/+M4UYi8D5gfBEDCDNZkzMpBfy/81VgB0WqNCNR5JHw6/uF8UZgjTqXtLacaAZoF05ZzdqEsBzw/YdmqEBPaPgJ+Ih3tHhuKNgSQH+0OPMzglrmkuZgaQGLLPrYrQap8+vWTg4mLUhS5Va+Q4/VpU/pkbQtKaMluaGCtUcOk9S3tVgwIqxgF/lzqpngtrSH5ErJc/Rp6pWhgliJA0z6KxgOQiyIp4PsXp2ZJ6OyNT+FPxLazsxwN/0M4H2KyQePt/xuNot69LAYpFzV/hSzhfdXbTBI70bPxUpf4KWvFVOXM4HbvLy7jdNFTlwGAREOtdCdw== 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 PA4P191MB1472.EURP191.PROD.OUTLOOK.COM (2603:10a6:102:10f::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5017.22; Tue, 1 Mar 2022 14:16:24 +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; Tue, 1 Mar 2022 14:16:23 +0000 From: Sebastien Flaesch To: pgsql-sql Subject: Global setting for ORDER BY ... NULLS FIRST / LAST Thread-Topic: Global setting for ORDER BY ... NULLS FIRST / LAST Thread-Index: AQHYLXZY9LzBDFcQmk6ziL7TBSLbQw== Date: Tue, 1 Mar 2022 14:16:23 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: suggested_attachment_session_id: c52473f5-cab3-4ce0-524f-2022cecbf744 x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 8ee58470-d1e3-46f6-8adf-08d9fb8e1109 x-ms-traffictypediagnostic: PA4P191MB1472: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: xsaaSlkrJKWfEhFzi867iKt842r5aZHEKHEV1m5aHJ+UfOrNR0vUbcdgAp0x29kasbUMrCcvhzbZZsV4FHZdWSSb7/68NBJyW8y733poxZk2Ch5Y9X9RmiqsOMCSWeLXH9Vp3c17cF3heQqoaC+v4Ib9h1ZClRClB8tpGyUGrrkXAVFTS9k5ut441PbAPZelzNfTd9jwZ6zuCrmZVjeF3dk4KttqTeny0Ug5C04SUIG/G+dk8jKasjhCPLsRgCWpVSUkvtelGPSJdDwOFcP5ZvbGH2rUX56OvIlpugvnQFtYB6oDzslIjry1TsssTF3vIRd/TjaJ4wK7lROOoiOSPcIlV8fIPgYXC2rGgsvO90IFqJQNvpGnHNtQ2ZxPHiilOzBjh5bnQqiLtPysiUvRG0OqiJDN3i+3AZam1rJ1NNm4nXUzI4+MwydroH36wUyzRnFTfXtprfymrFStQOo8cuW62ldg58fRNZjh1SCIoo9jLYvRnStGeMQ2FbCRRCZRot8RTMSqPVREVfkU9cF48yodH/D8mBNbsxL66V5ZnXJi7QFOoAl0o6PIk2hfs2XnI6u7Jml9kFrwxQMQhXJQMX7V+HhE6KbSSHKzX8zZBnCZ58rQZKlH2XMpqwlqcLwn6sw9nwTM59xpW6rBL2a5ZkXN+lMt02sCr4QKPWiJzkaEmZci5JePGiz/fEzjqktV4I9IqIR8uLJ/pRqLNPomnA== 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)(71200400001)(19627405001)(9686003)(38100700002)(6506007)(122000001)(83380400001)(508600001)(55016003)(6916009)(7696005)(8936002)(316002)(44832011)(52536014)(86362001)(38070700005)(5660300002)(2906002)(33656002)(4744005)(26005)(186003)(66446008)(66476007)(66946007)(91956017)(64756008)(76116006)(66556008)(8676002);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?c6AObTY7l/LHUmQ8OPmBI5FXCoZuVPGLTB5GlAC7u3SuV3QjtJMbzUE6nH?= =?iso-8859-1?Q?Tr2qhnQ3hCIgEaalX23rv71TxlT2lnCj95zBoH3Sl0qhqc1e4S8K6M/uff?= =?iso-8859-1?Q?9u4poNbH94OLOul4F0d5zFIEXoCZBg+GsJgc2+2yi7ynEnTDloZKS6Sr4b?= =?iso-8859-1?Q?0FvniiJ3KgHLBwfy/bLN4Es+8fC8FqExL9tX+Nzhp08etFv3BT+n4+v9NH?= =?iso-8859-1?Q?7Xr+S3ff4R5VONqZciL+KqSibVXnaVm5euOtFIS6Gf5eSv0Q40C35+bwm0?= =?iso-8859-1?Q?QqZ3oPhqS6eJwwuU5NEFRRZ8UQgQ5BBb3A2mQi4W2/7HZPjrNzM0iXPkFU?= =?iso-8859-1?Q?dQwsvZ6HwOUA3GiMm691HeUvn1jcDBK0feV2/lIQPpfZ7/cJByJakHR7mi?= =?iso-8859-1?Q?wdzfFRpa/2sFJwqOTibLyTldBqpyWU/Rhzr9R3CcfJMAMX4hhaDvU8vmEQ?= =?iso-8859-1?Q?ftvKOKlNh7A53RvAkSSOG7BECd+I9a++B9USpXOg3IIetjXWGXLB/gRqvj?= =?iso-8859-1?Q?PnY845rGyZLHEVODeqCgsFODt3RCy+g729u8ZVPZI/JXA5U9NnKoZ4tfQf?= =?iso-8859-1?Q?peAgnJhgFKneUBPRQVPlcbUoQY4satQ8HNxmIeCnnVK3JyMhKHMKNXX2X6?= =?iso-8859-1?Q?OPHWE453Orrroscy1AZNNHC+b3Z/8/z+pYdAem4KzYtv0LZIohzF6gGrgD?= =?iso-8859-1?Q?UoWwQ5GHFqWH5/2TWlJ0NzqOcXYc4dQf3bizLsQsmhGMbDKSJGJbLSUZ5D?= =?iso-8859-1?Q?fSnZ2OU2UICeW/uSv90OZLzlpY6oKeDh6oteN5g5807bgZXCbX5HqUY4fX?= =?iso-8859-1?Q?q6zFtlged63ZjtAP4+DGlI7eFSr85/IZTMmdIk7xbQo7S8xvpeTxJfpq4t?= =?iso-8859-1?Q?Tptpx1IRkvEuKYY/qzrZwEb1yt3UKpCpr/C/0RYXsEt9nRKx2QrH+pSIJ2?= =?iso-8859-1?Q?/aGRz11wMgGtoUSFlySv0yfxtQBrc91c0NDGWcTEudguluewoUpY5+Pfmc?= =?iso-8859-1?Q?oqPlxqnCN06XCRsHckE/YQOWeZtZm8uz6jBXs3Z3G+yuwRlTdX/eLiLwFL?= =?iso-8859-1?Q?dIdUsLNayLBbB/n/coRVKOx72e3nrpDOxVKc9b4laToPTEN/TYSkN9GE0O?= =?iso-8859-1?Q?C/5Sl09wRoer/w6SZUO8Rz9hGX/p8r+xNlTBlzUhepiS852D3uQBZeNJai?= =?iso-8859-1?Q?SUNvJbAnnidWzJ4XMiX96i5XilDkmAUqbg62vg0yNaYKU8ULfZkM8AVHD2?= =?iso-8859-1?Q?6XbF0TjxEqDetn1UvfEbNOLlghoqYcKc3aBHG70QZfYLQP84mBW5Q5pzKw?= =?iso-8859-1?Q?R7WxjC6A0Nnjeb6T6oQClRa0T+RjAPs9EGKe3N/FRmXrBixIjZUVztSbUo?= =?iso-8859-1?Q?fKF6dxziepLOW7xaI6cdbbJV5pTxpmaKAJKRo51YBVPpU4tDwq3uEYBgDb?= =?iso-8859-1?Q?DorSlILvmrFazK77A5x58rimlvj7NtYAi8vJB/MI5emAjyXPQoSSrGGiqt?= =?iso-8859-1?Q?P44e9AhL5tADl5iNBHCmfzLxmWNSNBHZ7nPU/4/nhQDE56ahODSFGGpoHL?= =?iso-8859-1?Q?r2783vWsfEddEp5919KMMo+EkvA8dzHW/auQEymRIaQdBffWYOJ8XIv1x8?= =?iso-8859-1?Q?4XE7ssh2Tu3cVuzxfv77osMLsl1A42K7ZOHN3kBV/gDszlFOWmzs2KhECA?= =?iso-8859-1?Q?Phno+/W2owVzloMridcmoK5MnuxRzBx0F2bvBlaIegiXVI2EKk9ITIvGy1?= =?iso-8859-1?Q?5N5A=3D=3D?= Content-Type: multipart/alternative; boundary="_000_DBAP191MB12893AA929975291A05E2938B0029DBAP191MB1289EURP_" 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: 8ee58470-d1e3-46f6-8adf-08d9fb8e1109 X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Mar 2022 14:16:23.8464 (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: CLZpK/tf80MhQhvGLbHDUlfe4WVXhwdqbt7s3WVlogzTIBjFdZyIVbIrcVL1uY/unPgMJ3Krd/mru8WF4F9i2kGZG/qVUVLg9xwIAnaSRIY= X-MS-Exchange-Transport-CrossTenantHeadersStamped: PA4P191MB1472 X-OriginatorOrg: 4js.com X-C2ProcessedOrg: 2f0c79df-a80b-40c2-9362-4c5fa2dae201 X-Proofpoint-GUID: xOWwcXhl0HoMtT0ZS0VgPxWtdComEdm- X-Proofpoint-ORIG-GUID: xOWwcXhl0HoMtT0ZS0VgPxWtdComEdm- 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-01_07,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_DBAP191MB12893AA929975291A05E2938B0029DBAP191MB1289EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello! Is there a global PostgreSQL server setting or SQL session parameter that d= efines 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 --_000_DBAP191MB12893AA929975291A05E2938B0029DBAP191MB1289EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello!

Is there a global PostgreSQL server setting or SQL session parameter that d= efines the default for   ORDER BY ... NULLS FIRST / LAST ?

Assuming that it would be something like "NULL is lowest value, or NUL= L 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
--_000_DBAP191MB12893AA929975291A05E2938B0029DBAP191MB1289EURP_--