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.94.2) (envelope-from ) id 1ruvIC-008XYG-Kv for pgsql-docs@arkaria.postgresql.org; Thu, 11 Apr 2024 14:20:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ruvIB-0019JY-8l for pgsql-docs@arkaria.postgresql.org; Thu, 11 Apr 2024 14:20:43 +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.94.2) (envelope-from ) id 1ruvIB-0019JQ-0L for pgsql-docs@lists.postgresql.org; Thu, 11 Apr 2024 14:20:43 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruvI8-000Noi-M4 for pgsql-docs@lists.postgresql.org; Thu, 11 Apr 2024 14:20:42 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 43BEKcdA171648; Thu, 11 Apr 2024 10:20:38 -0400 From: Tom Lane To: y.saburov@gmail.com cc: pgsql-docs@lists.postgresql.org Subject: Re: Mysteries of the future In-reply-to: <171276122213.681.531905738590773705@wrigleys.postgresql.org> References: <171276122213.681.531905738590773705@wrigleys.postgresql.org> Comments: In-reply-to PG Doc comments form message dated "Wed, 10 Apr 2024 15:00:22 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <171646.1712845238.1@sss.pgh.pa.us> Date: Thu, 11 Apr 2024 10:20:38 -0400 Message-ID: <171647.1712845238@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PG Doc comments form writes: > SELECT to_date('20000-1131', 'YYYY-MMDD'); > ERROR: 22008: date/time field value out of range: "20000-1131" What exactly do you find wrong with that? November doesn't have 31 days. Sure, we could have a discussion about the probability of the Gregorian calendar still being in use 18000 years from now, but it doesn't seem very profitable. What else do you want to use? regards, tom lane