Postgres Pro
Downloads
Home   >   mailing lists

[DOCS] Failing example for to_number() - Mailing list pgsql-docs

From Erwin Brandstetter
Subject [DOCS] Failing example for to_number()
Date
Msg-id CAGHENJ45ymd=GOCu1vwV9u7GmCR80_5tW0fP9C_gJKbruGMHvQ@mail.gmail.com
Whole thread Raw
Responses Re: [DOCS] Failing example for to_number()
List pgsql-docs
Tree view
The manual suggests here:

https://www.postgresql.org/docs/current/static/functions-formatting.html#FUNCTIONS-FORMATTING-TABLE

> to_number(text, text) |  numeric convert string to numeric | to_number ('12,454.8-', '99G999D9S')

The example fails for locales where the comma (',') does not happen to be the group separator and the dot ('.') is not the decimal point.

The example is incorrectly assuming en_US locale. It must instead work locale-agnostic. Replace:

to_number ('12,454.8-', '99G999D9S')

with:

to_number ('12,454.8-', '99,999.9S')


Regards
Erwin Brandstetter

pgsql-docs by date:

Previous
From: bramesh.ppl@gmail.com
Date:
Subject: [DOCS] why money datatype size returns with 2147483647 instead of 19,2
Next
From: "David G. Johnston"
Date:
Subject: Re: [DOCS] Failing example for to_number()