Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iwLoR-0000IS-Ne for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Jan 2020 08:01:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iwLnS-0004nR-7y for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Jan 2020 08:00:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iwLnR-0004nJ-4X for pgsql-hackers@lists.postgresql.org; Tue, 28 Jan 2020 08:00:30 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iwLnM-00048b-So for pgsql-hackers@lists.postgresql.org; Tue, 28 Jan 2020 08:00:28 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id 30459661; Tue, 28 Jan 2020 03:00:21 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute7.internal (MEProxy); Tue, 28 Jan 2020 03:00:21 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=EQmgDyV2lA0ifwIm0J8naURF9QLd61aFo+9dlzWjZ x4=; b=mT1acPLr9++eLu9frXR3n4wWxWUaJszkVRlXhC0Xz3f0Zx7HU9iGLc4KW zigqMlBtYKHXRwivVcjd3yOhfUrdb3BXgeBp0J0q2Guq6SbYHMDASrNfgTwKv6EC gCyXYiuM6gvifh52arCDyrKjCHwvw5lZmkg+agA1vvYt4zZdBvMagogLEhyExwju 9aKLYps8/RhcJsdtPmjbPJAiQuMFHEcn1BuOtWWev5FUiKBNOivsbggfOMK8eu8S eKVc+D+N/BjXZk0/rXe8EiR3l1ArQ9PN07LQ96M+mVI/F2pq9GrzB2pcnKPQ8n88 nmHgPXigfM01PeS+1yhqQWKm5I7sw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrfeefgdduudefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepuffvfhfhohfkffgfgggjtgfgsehtkeertddtfeejnecuhfhrohhmpefrvght vghrucfgihhsvghnthhrrghuthcuoehpvghtvghrrdgvihhsvghnthhrrghuthesvdhnug hquhgrughrrghnthdrtghomheqnecuffhomhgrihhnpedvnhguqhhurggurhgrnhhtrdgt ohhmnecukfhppeelfedrvdegvddrvdehhedrudduvdenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrrdgvihhsvghnthhrrghuthes vdhnughquhgrughrrghnthdrtghomh X-ME-Proxy: Received: from april.pezone.net (p5df2ff70.dip0.t-ipconnect.de [93.242.255.112]) by mail.messagingengine.com (Postfix) with ESMTPA id 272A7306B388; Tue, 28 Jan 2020 03:00:18 -0500 (EST) Subject: Re: Allow to_date() and to_timestamp() to accept localized names To: Mark Dilger , Tom Lane References: <20200124161814.GA8989@alvherre.pgsql> <32487.1579882979@sss.pgh.pa.us> <2f83150e-a2c0-6318-3125-d9b86e421aa2@2ndquadrant.com> <964.1579884408@sss.pgh.pa.us> <7212.1580177517@sss.pgh.pa.us> <2E3D8D71-3B55-4735-A047-1FECE1506CD1@enterprisedb.com> Cc: =?UTF-8?Q?Juan_Jos=c3=a9_Santamar=c3=ada_Flecha?= , Alvaro Herrera , Arthur Zakirov , Tomas Vondra , PostgreSQL Hackers From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Tue, 28 Jan 2020 09:00:16 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <2E3D8D71-3B55-4735-A047-1FECE1506CD1@enterprisedb.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-01-28 04:05, Mark Dilger wrote: > German uses both Sonnabend and Samstag for Saturday, so don’t you have to compare to a list of values anyway? Yeah, good point. If it doesn't accept both "Sonnabend" and "Samstag", then it's not really usable. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services