Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wIaK7-008EbZ-0P for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Apr 2026 22:57:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wIaK5-009C1W-2z for pgsql-bugs@arkaria.postgresql.org; Thu, 30 Apr 2026 22:57:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wIaK5-009C1N-28 for pgsql-bugs@lists.postgresql.org; Thu, 30 Apr 2026 22:57:33 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wIaK3-000000047Kj-2xS3 for pgsql-bugs@lists.postgresql.org; Thu, 30 Apr 2026 22:57:33 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.stl.internal (Postfix) with ESMTP id D0F767A00CB; Thu, 30 Apr 2026 18:57:28 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Thu, 30 Apr 2026 18:57:29 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1777589848; x=1777676248; bh=keGzbXbgJD EyPitkPfcsXfO9AYIiq/Ab0nZYrQSsSW8=; b=DKVQ/FpLyKRSnsa6KU3q+5RcxH zPPfBn6kPMpaHW11/3Bv/pJdpiZdTbukYdWJHjM7HQ4qgkOxYaZB2qDmYQxqw5Yv mhlfa3yA6jXfdUx0AkFfVyxnFQE5UUKWfqL6UUAgeNIpm6H3WxpeW9V0ISPk9E12 QxSk1E4olblXLdqC9hbPWC5jvc7B/NgJkToPe5bVoFOLLH9sR/89b34QWevTdN6x qQziQ5f9Qo4Dd8OTuJTMAf0Ip+wMRDN9fcaDu4zZ+lMWKYjKJrEf+YNtnsmE+UYw pBajAcEwbJfjk3nKP65aNzr+X3YcMgyRY1v3Wsr/haz+NDZ7swWgQ1htaA6g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1777589848; x=1777676248; bh=keGzbXbgJDEyPitkPfcsXfO9AYIiq/Ab0nZ YrQSsSW8=; b=Z6sHgqd80kw7JG9bixeNYvtpbn0RGQoJ/uCMAqw2430Ahva73gx BgtaOtu4UR9W7Zzu7Ll0aOE63i7DcgWJtRNjMlipi9fEXz6LhcuLmDEG3RI1AANQ QefZgU2p9URUkS5J6kDOZrlaFCcsug/aAzFMzhb/HDEDZdjCoosQBr9VwvT0XUax 1PZNZP09Wyr6gTQDXMKY0Gc7znqtPZ98BDZZo9jDR8HzDe5WHBsgvAU9FEhUFByu 8Awgt8rRfzf/ZFAJ3yH88MVKarIGkVTIMm5GwCytm0wSqFdQv1noTe7iiJQyBvqP RmSnFWFKPL3hDIUUcEC7aY6IRgnlYKayp5A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgdekkeehkecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlh cuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddtvden ucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquh hivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeggeff hfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtnecurf grrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhn sggprhgtphhtthhopeehpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrhihush hhthhifigrrhhirdhslhhgtddusehgmhgrihhlrdgtohhmpdhrtghpthhtohepphgvthgv rhesvghishgvnhhtrhgruhhtrdhorhhgpdhrtghpthhtohepthhglhesshhsshdrphhghh drphgrrdhushdprhgtphhtthhopegurghnihgvlheshigvshhqlhdrshgvpdhrtghpthht ohepphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 30 Apr 2026 18:57:26 -0400 (EDT) Date: Fri, 1 May 2026 07:57:22 +0900 From: Michael Paquier To: Ayush Tiwari Cc: Peter Eisentraut , Tom Lane , Daniel Gustafsson , pgsql-bugs@lists.postgresql.org Subject: Re: to_date()/to_timestamp() silently accept month=0 and day=0 Message-ID: References: <1444609.1776958814@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Ck8zZ2bL31+iYg5K" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Ck8zZ2bL31+iYg5K Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Apr 30, 2026 at 07:44:24PM +0530, Ayush Tiwari wrote: > I'll add this to the commitfest, so that we can circle back on this > once v20 development starts. >=20 > I think parallely we can commit Daniel's v2 patch, since > that correctly documents what Postgres has right now, and we'll > know what exactly to change if we decide to go the other way. I'll leave that up to Daniel, I guess, as he has sent the patch. All this stuff qualifies as v20 to me, including the new tests. Now, I don't see a reason against committing the new tests now. I doubt that this are going to impact the buildfarm, and we are still early in the beta period. I may be wrong about the buildfarm part, of course. :) -- Michael --Ck8zZ2bL31+iYg5K Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnz3lIACgkQnvQgOdby QH3xNhAAnd+ctur8XNPNpPgREDC1Lsur/nSg2ugWt3812ULqs1HUlMcpsksZCtsL T4+NVTfWbCH3FPmIjDXBjErUUmqwy9Z3eBprKzCyamhd5hoGDBhcdfK+OUqYdCS5 TB1WzUCZwJSdui1xo1T/wmUHtIQyweY+LGhltvquO+njTxAGvl4bJPvrMT5caz2S 9bc1cfoPJOCN9+TPgmFnEZJeMG1ernJZg+RfuG7MNmDeW2B3a767QkjsBy3d96bB eErIjwN000Q5M3eU6BL7a14X0pientc26m5zmPLBUuD/vjX5NdhOH65vaassFJKq mko5ACiROCIwZkhDCjLaGTnhe0a8or7xULMcUQj5UjTBt/gBgKwzTK5NxZr3T0ss AripaLhd/Wd1AjWlpmrJ3BRN+CmvB38K0Ojr0vtPiHpytqn+w7RXWzyiLG9ySVAR tY0OQxErY3VKPKO8XpUClvEBqoOO3lnLvaG8AHwOsOnPlJhOOi8R0ROFOYt99SB6 nIjCPzWU+OctYe0S6I4m8uWUBhIC/25riiCloJEFRZeZdI1eZw1bB5Sk5arTkT/h 8p66x7EU18+IoUuNrMy7qOo8r4wBV3TGKW2x2XX2xl6KKs3cnIkwYUhsHiq10O9c rLc4ov9It5fknzWFqN0EasrgbG9aTmUmxeJfMKIw7ReRUsgajhs= =tsdS -----END PGP SIGNATURE----- --Ck8zZ2bL31+iYg5K--