Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YRG0z-0002gi-Le for pgsql-docs@arkaria.postgresql.org; Fri, 27 Feb 2015 08:11:18 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YRG0y-0007hv-Vu for pgsql-docs@arkaria.postgresql.org; Fri, 27 Feb 2015 08:11:16 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YRG0x-0007hl-LT for pgsql-docs@postgresql.org; Fri, 27 Feb 2015 08:11:16 +0000 Received: from mail-pa0-x230.google.com ([2607:f8b0:400e:c03::230]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YRG0p-0006eL-Km for pgsql-docs@postgresql.org; Fri, 27 Feb 2015 08:11:13 +0000 Received: by pablf10 with SMTP id lf10so20873500pab.6 for ; Fri, 27 Feb 2015 00:11:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:to:subject:date:message-id:mime-version:content-type :thread-index:content-language; bh=hfHMqKuAZotHRuPkONr/9UbC6jIutjhEB0DImmH5gP4=; b=RYoXCWcCAAHEZjR2/a5LzsLryJAVo3kWNgTeFms6aDrmCwylpkdPlZ8S2hT4fNBaXH x3+MF8FybY1skuSQXsV4BbEK7j2mPJjSnbJ3A0T4cgG5L+em0/cVoWCueydNiGcq+EbS B2x1tfVpJyEvUqBKxWlJxIbPeYJ1Ir2YHOMRf4EIP/b+kVFio7uzYaL2xgf/SDHUviA/ hcG3ler8BwnWTWqnjVaibtd//ThXT3SNrhcLhMNi0JvphctYc0lgg5iVsr9EUMaFj+8i TNNM8HTZ9pn7CkYJJwfWIiiEA7F7xKYs3734PpKURZmQb+lebsHPell/RSSFOz1zm/PE pf+w== X-Received: by 10.70.52.8 with SMTP id p8mr21791416pdo.27.1425024666188; Fri, 27 Feb 2015 00:11:06 -0800 (PST) Received: from YuanyuanPC ([58.58.27.50]) by mx.google.com with ESMTPSA id br14sm3157534pdb.38.2015.02.27.00.11.03 for (version=TLSv1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Fri, 27 Feb 2015 00:11:05 -0800 (PST) From: "liuyuanyuan" To: Subject: Threes errors of to_char Examples Date: Fri, 27 Feb 2015 16:10:40 +0800 Message-ID: <01bf01d05264$e842bf00$b8c83d00$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_01C0_01D052A7.F66BA450" X-Mailer: Microsoft Outlook 15.0 Thread-Index: AdBSYrcgctjxYlxUT5Wc3tU/NYp7qA== Content-Language: zh-cn X-Pg-Spam-Score: 0.2 (/) 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 This is a multipart message in MIME format. ------=_NextPart_000_01C0_01D052A7.F66BA450 Content-Type: multipart/alternative; boundary="----=_NextPart_001_01C1_01D052A7.F66BA450" ------=_NextPart_001_01C1_01D052A7.F66BA450 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable Hi all! I found three errors in postgresql9.4.1document, they are about to_char examples. Maybe other version of document also have those errors. Please Check and modify~ =20 In Chapter 9. Functions and Operators of PostgreSQL = 9.4.1 Documentation, I found this: expression result to_char(148.5, '999D999') ' 148,500' to_char(3148.5, '9G999D999') ' 3 148,500' to_char(485, 'PL999') '+485' =20 But, in fact their result are as follow: =20 postgres=3D# select to_char(148.5,'999D999'); to_char ---------- 148.500 (1 =D0=D0=BC=C7=C2=BC) =20 postgres=3D# select to_char(3148.5,'9G999D999'); to_char ------------ 3,148.500 (1 =D0=D0=BC=C7=C2=BC) =20 =20 =20 Yuanyuan Liu Blog: http://my.oschina.net/liuyuanyuangogo ------=_NextPart_001_01C1_01D052A7.F66BA450 Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable

Hi all!

I found three errors in = postgresql9.4.1document, they are about to_char = examples.

Maybe other version of document also have those errors. = Please Check and modify~

 

In = Chapter 9. Functions and Operators of  = PostgreSQL 9.4.1 Documentation, = = I found this:=

expressio= n

result

to_char(1= 48.5, '999D999')=

' 14= 8,500'=

to_char(3= 148.5, '9G999D999')=

' 3&= nbsp;148,500'=

to_char(485, = 'PL999')

'+485'

=  

= But, in fact their result are as follow:

=  

postgres=3D# select = to_char(148.5,'999D999');

to_char

----------

  = 148.500

(1 = =D0=D0=BC=C7=C2=BC)

 

postgres=3D# select = to_char(3148.5,'9G999D999');

  = to_char

------------

  = 3,148.500

(1 =D0=D0=BC=C7=C2=BC)

 

 

 

Yuanyuan Liu

Blog: http://my.oschina.net/liuy= uanyuangogo

------=_NextPart_001_01C1_01D052A7.F66BA450-- ------=_NextPart_000_01C0_01D052A7.F66BA450 Content-Type: image/png; name="image001.png" Content-Transfer-Encoding: base64 Content-ID: iVBORw0KGgoAAAANSUhEUgAAAYgAAAB0CAIAAAAQBjKnAAAAAXNSR0IArs4c6QAACzdJREFUeF7t nb2u3EQUx9deXgNqBEhIPEFEIqhIFKVIKJIgIYRS0CHxobsIiqTkDdIgIToKBAWhIAIiJRQpkICa grfIvZex52YyzJdnvLZ3PPOzrqKNdzxzzu8c/31m1rturt5+uOm3mxdeONrtHt+7K//LBgEIQOBQ BNpDDcy4EIAABHwEECZyAwIQyI5A22ya7IzCIAhAoG4CXcUktAl5qjsN8B4CeRFgKpdXPLAGAhAQ BBAm0gACEMiOAMKUXUgwCAIQ0IWJVXDyAQIQyIIAFVMWYcAICEBAJ4AwkQ8QgEB2BBCm7EKCQRCA AMJEDkAAAtkRQJiyCwkGQQACCBM5AAEIZEcAYcouJBgEAQggTOQABCCQHQGEKbuQYBAEIIAwkQMQ gEB2BBCm7EKCQRCAAMJEDkAAAtkRQJiyCwkGQQACzbXbjySFG91TUo4KfkrK/fv3hZvnzp1TL8Lh l83kJo6SL/Sd+rvOxoH2dm9yCLt/NfRBklXZM6EZPv7G/kj++xhmW+Lj74uvETLdmJiUMIx3kolM 14Okx3yDzlsxOU/j+ZyZsGeVDYZeqEwSL+RmKJeRar72KqFVJ7YExJ9y83GOtyESfliVVCc+/oq2 wT9y9MFmRrz0MBmB1i8tdhB99of9cprnu2IN+rLqBjMK03xnywjiyhj7xYje9ENST109z+xjfboW MDIrzmGYkaq0Z0TKO9ynTYKn3MpzuW2a//0+nPLT9lntMUA49+vnv8FO79k5nK99zLjyEmdsYudg aRMIrV4ZGc1Sc8LXPjBEzKmue60XHUmJ64uv0WG4f2dwjeLCydCp76l4k85Pn0omdTJh47A9tdVN ZsWk/DeqU0XNAOTb75vC6O31SNh5Kd9NHVdqkLGNyB7lpu/cMNRzcIjU9oMdygYxnBXGwbLLnpLo MmSEXp9MKUq+OPqG9p2Nqh9ngyTB9Q0dvhioeIUrYl+epO5XeRsZdxX90Ze0pIGWb7zvVE5P1kkY iYRwJrchEIFxnRXTCLKBszQmjWyDwyk+wsKZDnHG0ReUgHDH+6urtnFB0qst46oTI7ijEemy6+xE 12L98qAa6xh1FL79o00t8sB9hUnlylQVgQyhcW7oFZAReHtcvbEtLiqfwtME44Lpa+w790a0D9uT W/IZlaxtnh1Ho+AyrvnOc1svCbMisHyw5qscswKrjOkfeNlv4+yLOYF17fCVuDGjG9dVPVSDiWLn ffz1PGzb4NDG4Ulmx2BRbaa6NkzVj0+tUonp/YRtm2SKl8RcL+icRaVTW50qExg3tf0IF3I7pHn7 zu/SpusXnj866u5jck6aRAN9vx4D3379EKcK+E5Ro/GIcZ2U1XCRYXaO6zyphMGp+/WEVrVDYGek OEbGJcDHZ4wxdzaCa7A1OglIs66q6rVdW0X6paIw+qoTk2w+O315G7nfF+JwukYmc266M2iPV5hG hzbmFLKzfNBQGkxCwFetzBTuSWyO7KTUU7TOSsoUpi8/vW5cECLTIr5ZoMKK74SWEIBAwQQcFVPB 3uIaBCCwCgITfCq3Cj8xEgIQWBEBhGlFwcJUCNRCAGGqJdL4CYEVEUCYVhQsTIVALQRyEaZD3RpX S5zxEwKrIpAmTPvcsxvGUsB9NKuKO8ZCIGsCCcI0nyplTQjjIACBxQnE3sdkq5KqcVJvmAzf9a++ 3hHuX//yQYW3/C6eJwwIgUUJxFZM+pdg9a/+K1FwfnfcdmWwvWhgdCWHs3canVPQLZo4DAaBOQnE CtMcNugCp/p3fkVbLo07bVBCNoeF9AkBCByEwCGFKcZho8KyD5FC5tS4mP5pAwEIZEhgjDAF6pck D6fqJ2lQGkMAAvkTSBAm52+VqJ2RK9C+9uGf45ASphug2rO0lH+SYSEEUgk01+48ajbdz1eqH4pL 7cK39OPcz/1Kk+ClEwiUTaATJuGh0KZphalsangHAQjMSiBhKjerHXQOAQhAQBFAmEgGCEAgOwJn wnS6Oc3ONAyCAARqJUDFVGvk8RsCGRNAmDIODqZBoFYCCFOtkcdvCGRMAGHKODiYBoFaCSBMtUYe vyGQMQGEKePgYBoEaiVwdue3cP/GhReOjo70J/EqJurH2wxKK9pfa3zxGwKrJGAK0+N7d1fpB0ZD AAIFEWAqV1AwcQUCpRBAmEqJJH5AoCACCFNBwcQVCJRCAGEqJZL4AYGCCCBMBQUTVyBQCgGEqZRI 4gcECiKAMBUUTFyBQCkEEKZSIokfECiIQHvabwV5hCsQgMDqCTz9BUu0afWhxAEIlEOguXq7e0rK ZnN6U3xXbreb4yspxiPn9CfBqac52Y+H40FP5WQZnkAgkcDsa0yG4hiP/DbelU/65nnfiUGkOQRK I3C2xiRmcmKdKWapKem53jwmt7R8wR8ILEKg3cjV79OTTpcmXWkKPDQcwVokuAwCgbUSaI9Pjk/E X//RXPjjOb1WGqybfKpkLCoZC0myW2RrrdmE3RCYiEB7cnrSCdPJsSiawsKkL/1ELgMZWiZs9i2E G6tLaNNE8aUbCKySQHtyLGqm41PxJ6umiTZ7GdsojvjQbSLSdAOBAgl0wtRvT/qFpmFhiqyVUlEx g0slRnsIFEygFZIktOnJkydiRtcvgU+8qUmZPolTMqTqJvnC3j+xNXQHAQisgUDz5oc/yA/j3r/0 0u5o9+cvX6/BbGyEAARKJiCmcl2pJP7kfQMl+4pvEIDASgi0Tz+Pkx/JIUwriRtmQqBoAq1Y8BYl k1SkmWSJz/6LTiGcg8D0BJrXP/h20zRt09y6/Ir4Eu/fv34z+SBCmNTatt25ft+AahlpQ1jyuCMh EiPNIJAbgeZ8L0xCmm5dfnm32/01tTCN0JpJfnIgddzcAoM9EKiZQNsKWeqncUKcNpv+5XTbnuqg 36VJ+TNdWOgJArkTaMUkrm3Ev93vn/Ta9Gxz3vQYv2AUnsH5wKQKkPp6nfHC7p97OHNPRuyDwFMC Qpc2216Z5KbIOL+FG69Kop9UiRkXFKOqCvycU2Cda9zQHAUBCMxEoN32mrTdbnVhslVpdLmh102B 6kZ/ayZXlVYmyet8xtAzBCDgI9C8Je78blqxwvTexRd3u8/++PkrZ60kjw+85RzA1z6w9qS/ZStI YF08EGP7x1UWK+jIPAhAYAyBSx/9ePHjexc/+em7B/+8ev4dqT6+miKpbpKdOLsK1Cz6W0azwUpn sIGS18iWY4ByDAQgsDeBdtO27XYr/ow1pj17DtREo3u2F63C+oL6jEbNgRA4LAGhSs91qrTdigmd XPyeZJF4sZVvX1XlU8bU2ehhw8PoEKiTgPxAbisKp6a7iensU7lJtGkZoIap4r9yvulURlRpmaAw CgT2JNDdxtTdYtndaHl2q6Xs0Tjh9dWlpJWmcfZFLkKpNSNdhnzFGqo0LhYcBYEDELjy+W/y7/uH /772xruTWzBi8VsdMnisIZHGwjlrTJNHkw4hsAyBvlySf4tsMWKhSh41L5MCZFdt8nZKYbjdrXxr geJuEWwMAoHKCFz54oH8W6xiitGmEUGYqdsRlnAIBCCwJ4HZHxFur/jM9IHdTN3uyZfDIQCBEQRm F6YRNnEIBCBQOQGEqfIEwH0I5EgAYcoxKtgEgcoJtDwZpfIMwH0IZEiAiinDoGASBGongDDVngH4 D4EMCXTC1D/pcqZHN2XoMiZBAAK5E3hWMSFNuccK+yBQDQGmctWEGkchsB4CCNN6YoWlEKiGAMJU TahxFALrIYAwrSdWWAqBagggTNWEGkchsB4CZw+6XI/BWAoBCJRPgIqp/BjjIQRWRwBhWl3IMBgC 5RNAmMqPMR5CYHUE/gOTYXIbLczHZgAAAABJRU5ErkJggg== ------=_NextPart_000_01C0_01D052A7.F66BA450--