On 28 August 2017 at 22:53, Tom Lane wrote:
> Erwin Brandstetter writes:
> > On 21 August 2017 at 16:30, David G. Johnston <
> david.g.johns...@gmail.com>
> > wrote:
> >> On Mon, Aug 21, 2017 at 5:36 AM, Erwin Brandstetter >
> >> wrote:
> >>> The example fails for locales where the comma (',')
Erwin Brandstetter writes:
> On 21 August 2017 at 16:30, David G. Johnston
> wrote:
>> On Mon, Aug 21, 2017 at 5:36 AM, Erwin Brandstetter
>> wrote:
>>> The example fails for locales where the comma (',') does not happen to be
>>> the group separator and the dot ('.') is not the decimal point.
On Mon, Aug 21, 2017 at 7:55 AM, Erwin Brandstetter
wrote:
> On top of this (separate issue?) ',' and '.' are ***not*** interpreted
> according to the current LC_NUMERIC setting. I.e.: even with (example)
> Austrian locale, ',' still is interpreted as group separator and '.' still
> is the decima
On 21 August 2017 at 16:30, David G. Johnston
wrote:
> On Mon, Aug 21, 2017 at 5:36 AM, Erwin Brandstetter
> wrote:
>
>> The manual suggests here:
>>
>> https://www.postgresql.org/docs/current/static/functions-for
>> matting.html#FUNCTIONS-FORMATTING-TABLE
>>
>> > to_number(text, text) | numeri
On Mon, Aug 21, 2017 at 5:36 AM, Erwin Brandstetter
wrote:
> 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
