Andreas Joseph Krogh <andr...@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