Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YRZk7-0006e9-00 for pgsql-docs@arkaria.postgresql.org; Sat, 28 Feb 2015 05:15:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YRZk5-0003YW-Ur for pgsql-docs@arkaria.postgresql.org; Sat, 28 Feb 2015 05:15:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YRZk4-0003YF-Uo for pgsql-docs@postgresql.org; Sat, 28 Feb 2015 05:15:09 +0000 Received: from mail-pa0-x230.google.com ([2607:f8b0:400e:c03::230]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YRZjw-00053J-Ga for pgsql-docs@postgresql.org; Sat, 28 Feb 2015 05:15:07 +0000 Received: by paceu11 with SMTP id eu11so27895093pac.10 for ; Fri, 27 Feb 2015 21:14:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:to:cc:subject:date:message-id:mime-version:content-type :content-transfer-encoding:thread-index:content-language; bh=Pc9+882vs1mG2vRmdjOOamlDKj7sRoktj9yrjeXN57Y=; b=EfenaYN2B4JMWRS8pZ22J5YPe56If8/jm595c4n0OmFMTIz+rd6QR2AfhIzo7JJmyc jkEqGG4tdL4h3AvWbitGmBbsjTlrTMOV37ckQHZOZDwRs+msp5GyXS5wIx1qaSeGl1NV Z23jJ6FZTQWN1jEWsj02Xo8HG7P7qqgiJKAgbytdxhqWLdR8YB1RVLHapAf+iz0B9r0Y zilRft/O2k25RUZ1HvguMCe2mz1LqStM7BN2zaEooeV+OJv9ZUWlkf05XpQZ/fz9KqIU 4usjXK12rG/4ENyPjGEln399NXeNab9N9/JQJYeanMIcq5cZMQUckpBYK1SBVFeDwM0m acOw== X-Received: by 10.70.132.131 with SMTP id ou3mr3184229pdb.159.1425100497786; Fri, 27 Feb 2015 21:14:57 -0800 (PST) Received: from YuanyuanPC ([58.58.27.50]) by mx.google.com with ESMTPSA id du13sm5483280pdb.65.2015.02.27.21.14.54 (version=TLSv1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Fri, 27 Feb 2015 21:14:57 -0800 (PST) From: "liuyuanyuan" To: "'Tom Lane'" Cc: Subject: Re: Threes errors of to_char Examples Date: Sat, 28 Feb 2015 13:14:34 +0800 Message-ID: <01eb01d05315$787422c0$695c6840$@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 15.0 Thread-Index: AdBTCffAqQ/Cq6MzRPSsCy/H0Pdvvg== Content-Language: zh-cn X-Pg-Spam-Score: -1.7 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org "liuyuanyuan" writes: > I found three errors in postgresql9.4.1document, they are about to_char > examples. Tom Lane writes: >the cases you mention vary depending on what locale you're using. Thanks for your reply! I know pattern D and G depending on locale. My default locale is zh_cn, but when I init DB using locale=en_us.utf8, I still got the same result. I haven't use other locales to test any more, maybe they will bring different results. Whatever, I think it's better to report here. Maybe declaring the locale for the examples is better, if possible. Regards! Yuanyuan Liu -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs