Failing example for to_number()

From: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Failing example for to_number()
Date: 2017-08-21 12:36:27
Message-ID: CAGHENJ45ymd=GOCu1vwV9u7GmCR80_5tW0fP9C_gJKbruGMHvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2017-08-21 14:30:15 Re: Failing example for to_number()
Previous Message bramesh.ppl 2017-08-21 08:28:51 why money datatype size returns with 2147483647 instead of 19,2