Postgres Pro
Downloads
Home   >   mailing lists

Thread: Threes errors of to_char Examples

Threes errors of to_char Examples

From
"liuyuanyuan"
Date:

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:

expression

result

to_char(148.5, '999D999')

' 148,500'

to_char(3148.5, '9G999D999')

' 3 148,500'

to_char(485, 'PL999')

'+485'

 

But, in fact their result are as follow:

 

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

to_char

----------

  148.500

(1 行记录)

 

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

  to_char

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

  3,148.500

(1 行记录)

 

 

 

Yuanyuan Liu

Blog: http://my.oschina.net/liuyuanyuangogo

Attachment

Re: Threes errors of to_char Examples

From
Tom Lane
Date:
"liuyuanyuan" <liuyuanyuangogo@gmail.com> writes:
> I found three errors in postgresql9.4.1document, they are about to_char
> examples.

All the cases you mention vary depending on what locale you're using.

            regards, tom lane

Re: Threes errors of to_char Examples

From
"liuyuanyuan"
Date:
"liuyuanyuan" <liuyuanyuangogo@gmail.com> writes:
> I found three errors in postgresql9.4.1document, they are about to_char
> examples.

Tom Lane <tgl@sss.pgh.pa.us> 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