Re: lc_numeric and negative-prefix - Mailing list pgsql-general

From Tom Lane
Subject Re: lc_numeric and negative-prefix
Date
Msg-id 29374.1569452008@sss.pgh.pa.us
Whole thread Raw
In response to lc_numeric and negative-prefix  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: lc_numeric and negative-prefix
List pgsql-general
Andreas Joseph Krogh <andreas@visena.com> writes:
> Can anybody shed som light
> on when negative-prefix is supposed to be respected by PG's
> formatting-functions? In lc_numeric='nb_NO.UTF-8' negative-prefix is '−'(8722),
> not '-'(45), at least in the JAVA-world, but it seems the JDBC-driver must use
> lc_numeric='C' when parsing server output. -- Andreas Joseph Krogh CTO / Partner

PG does not consider LC_NUMERIC at all when producing output from
the standard numeric data types (and we aren't going to start).
AFAIR the only functions that do pay attention to LC_NUMERIC are
to_char() and friends.

            regards, tom lane



pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: lc_numeric and negative-prefix
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: lc_numeric and negative-prefix