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 1iwTce-00024j-7Q for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Jan 2020 16:21:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iwTcd-0005HD-0R for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Jan 2020 16:21:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iwTcc-0005Ev-KF for pgsql-hackers@lists.postgresql.org; Tue, 28 Jan 2020 16:21:50 +0000 Received: from mail-qt1-x843.google.com ([2607:f8b0:4864:20::843]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iwTca-00020z-5E for pgsql-hackers@lists.postgresql.org; Tue, 28 Jan 2020 16:21:49 +0000 Received: by mail-qt1-x843.google.com with SMTP id t8so5223634qtr.2 for ; Tue, 28 Jan 2020 08:21:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=YFAodSJTWKOGEPaLSYMY7dbbMRSwv8dt6JGSU7DI82I=; b=ucOW0kMS1I11fwx3VVoLecspLnVLlLPoBqQZsyJdWmfjsV3Ln7wTPtOHLkpaN9uYvs LhymzLlIWS0hmq53q4E3IgePF48rLhJwDuI4TuWvqwzhylqQfr2cbXsg68U8IkGe+yY3 x6o1ME3+heD8Z1dsHwimy14KqDyoowtd7Ww/u3Mdy2EFFMBWAO7I9sNufw2egrl2D4/d wVO04P+Y7hMy/h+YqiuxZb+tBOw7NdgGrCDuTWrhMYfdugS+Z2yXsZ26a8XdAxDzm22H TBsr5SWgNVZSVGMIa72IMWGKWMUbobhGXX2pVqoOgWGCdblefelJFTmYVaLU2zwD5hft o9Eg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=YFAodSJTWKOGEPaLSYMY7dbbMRSwv8dt6JGSU7DI82I=; b=Yv20a3gIJgKFY1gaAzaVyYSiXcxe4zKLRV03cavqMVbey6EzMio798FUo41aIk8bYI HYtXV/9+BWL3iI0esyV6NDYeQpzivOhZ6yf8FEoRi13qVivnRD+6FKtoRmgrPsc587s8 VFXnqApFWy5hzg6zqgezgCFuYdgqQNaSqtkTqK2GBfZUG1xkXO4IJnybNEKp5EKeDNUm KcN3jgNL6gyB9SkKFY9Cm/OuDIpcsP44wfvfLxJsPNYa16tVNt1Rbx90EqbmgPuJaSui JeL2fZGZ7p1pRC42AZZjA47+1Ksmcyg+QOoHl1mzxeCQSI2Rpz34ujW6VvQZPWfJSmGV 0vLg== X-Gm-Message-State: APjAAAWaVSQ90Uojdns0oPiPRtVDavZ8K3kcXSJi8duuu+XLyBqnm78V nQ8KNQGXsv47KtMTrE770EZlfw== X-Google-Smtp-Source: APXvYqx87PfN58lmeFQXa4sdqN/rcpSJKIKTFR2a/KeQhNpSqLOM4J3h92o6R/QgUYq0x2jA81H1xw== X-Received: by 2002:aed:27de:: with SMTP id m30mr22260580qtg.151.1580228507170; Tue, 28 Jan 2020 08:21:47 -0800 (PST) Received: from nimloth.alvh.no-ip.org ([179.56.30.174]) by smtp.gmail.com with ESMTPSA id v2sm13038246qto.73.2020.01.28.08.21.46 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 28 Jan 2020 08:21:46 -0800 (PST) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 51E7B3007FC; Tue, 28 Jan 2020 13:21:44 -0300 (-03) Date: Tue, 28 Jan 2020 13:21:44 -0300 From: Alvaro Herrera To: Peter Eisentraut Cc: Mark Dilger , Tom Lane , Juan =?iso-8859-1?Q?Jos=E9_Santamar=EDa?= Flecha , Arthur Zakirov , Tomas Vondra , PostgreSQL Hackers Subject: Re: Allow to_date() and to_timestamp() to accept localized names Message-ID: <20200128162144.GA21427@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Jan-28, Peter Eisentraut wrote: > 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. The string "Sonnabend" never appears in the glibc sources, so that will certainly not work. I vote not to care about that, but of course my language is not one that has alternate weekday/month names. I guess if we're intent on recognizing alternate names, we'll have to build our own list of them :-( I don't have the ICU sources here to check the status there. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services