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 1wG2JZ-005onS-0T for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Apr 2026 22:14:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wG2JY-003MnP-1D for pgsql-bugs@arkaria.postgresql.org; Thu, 23 Apr 2026 22:14:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wG2JX-003MnG-25 for pgsql-bugs@lists.postgresql.org; Thu, 23 Apr 2026 22:14:28 +0000 Received: from fhigh-a5-smtp.messagingengine.com ([103.168.172.156]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wG2JV-00000002TuD-0m6R for pgsql-bugs@lists.postgresql.org; Thu, 23 Apr 2026 22:14:26 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfhigh.phl.internal (Postfix) with ESMTP id 693051400049; Thu, 23 Apr 2026 18:14:24 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-05.internal (MEProxy); Thu, 23 Apr 2026 18:14:24 -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=1776982464; x=1777068864; bh=otP0bNkaRs 6ISZGK4cbPnlFlCFn7lMZQvojmeutbDE4=; b=BbK1m9Xmy2apRSUf+CUzQnIaI8 2r3b80OKptwEDecFycsRKOvuoZsAMOY+EwiVzeqaJeDspkkhCbBV6um4OydDpB+T nykTYtabNOy0c/yg+QO7Rt6CQ/KXhTeMLOZkL4Fm18iaO1lXoPOZ3Z0XmUAeJw5B 2X2or5nvwBTpphxKStuSi/oBlXX3J0GtaKxQQC5NVAcEkzoMrvqFKrcfZ0Uy9pl+ J9XSqg3B1UYM302B6x/AcdMOuNdNI4aV2mddr6L3SNaR5EHj4bTiDYNLsNLvxH+Y GXAkfPmZKbCzyNSeMeRGHzsrULKl/M3cE28qLcgxMxZCFasOOmSu93NiGQTQ== 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= 1776982464; x=1777068864; bh=otP0bNkaRs6ISZGK4cbPnlFlCFn7lMZQvoj meutbDE4=; b=rywUPxMEK9AhEU1ObCxvH5R+rIToE+wqWk3FJn+Bur7x8JsrFGo IkLD3wIHNg6UuRA8LXdAyamHV1bThY0Uhw0NZzmWjqY5ismbDCOLzzBeyh/ykl9T IpmND/eV0mPUvCno17NWFT6Vz1BvxB76Ahs5KNt1n4Xpvf0GoMkjQJXizYfmnX2j LtWQtj7s1Z3N0m8uHK9XK2L8e2tsnh/wPhkJ5F049a4+pnc9im3VfpspQ+Z4bPy3 KF99aOZHyseTr5sQpQOfgew9rolvF2hDBWQHxjg4KRyEnvp+aC8lyGkt/XbqMBU/ plYHmMugxMlKyM1oQS4lalrWYAjXoZe3ClQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgdeikeefvdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlh cuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddtvden ucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquh hivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeggeff hfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtnecurf grrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhn sggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrhihush hhthhifigrrhhirdhslhhgtddusehgmhgrihhlrdgtohhmpdhrtghpthhtohepthhglhes shhsshdrphhghhdrphgrrdhushdprhgtphhtthhopegurghnihgvlheshigvshhqlhdrsh gvpdhrtghpthhtohepphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhq lhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 23 Apr 2026 18:14:22 -0400 (EDT) Date: Fri, 24 Apr 2026 07:14:18 +0900 From: Michael Paquier To: Ayush Tiwari Cc: 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="TSSxXcL2noS8rUuX" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --TSSxXcL2noS8rUuX Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Apr 23, 2026 at 10:06:41PM +0530, Ayush Tiwari wrote: > If we are not going to change the behaviour, imo, we should > atleast add a test case to depict this scenario and comment > that says this is expected behaviour according to the community. Yes, we could close the gap with some tests, at least. -- Michael --TSSxXcL2noS8rUuX Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnqmboACgkQnvQgOdby QH1q4w//WCJ0uP/fxkaXU9LMhk5f4PlFBlLXND8I0RXljRAsYcgyMzzjIul7o9A/ dHWKqRIRFa1AqSXXhh5KgkHCvfGOHo6fZPN5e9aH38lv19xIWfHwvI47iSERTJDe Tckv4JgGB380hEASOo+ngHIm8dBqXV7FDtGWIPVFLyZwq5XP5ng5K6trXpjqyJcK LXat993EC8XP9VcGzySe3zCqsh8K395Ni8Zj9GSWdW2JaAZMvwAwNNvovsO26CpB TphZp8C0gLy6O38pc2ZNgfrCqZz8RJV3Zagkdk+lsADBzRDQNeltnLqNGurUSVVL +fmtInj9vlrtQKsx+Zvj+Wp08Cm2phC2TnAZc8seKgr4pS9YVDRd+OqycBVrkFKX nijr7/YTFDoujXxooDBV7ulvdY9rMkBi18AM9dxXpLkCUlg62r/2GqF+rsZmRqcX /bybYBvjSqK2QEZHCGP8CPEk89/CWmta5yK7ujGVXQTBOh5gTxlJHSK9sfIKrcsf nKS09qky4MZl+yz0DC6dCWWqiNpDlTfXqEfdeSFAoJ4sYcl3W2BYtglWixgUlKdz OouIAPs4nO2AjR9DJTwviQllaAuyaB7fBuCXImTP2w3bIhwnSAHKGEA4InOLIAXf E1M1wfRDZ4+eq2UjqFnal99hp8GkQUXb24KPhszG03+yFDzWZUA= =3ik0 -----END PGP SIGNATURE----- --TSSxXcL2noS8rUuX--