[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: lc_numeric and negative-prefix
From:       Andreas Joseph Krogh <andreas () visena ! com>
Date:       2019-09-25 23:00:07
Message-ID: VisenaEmail.2.ca0eeb68bbbb2fc3.16d6aa6a359 () tc7-visena
[Download RAW message or body]

[Attachment #2 (multipart/related)]

[Attachment #4 (multipart/alternative)]


På torsdag 26. september 2019 kl. 00:53:28, skrev Tom Lane <tgl@sss.pgh.pa.us 
<mailto:tgl@sss.pgh.pa.us>>: 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 Thanks for clarifying. -- Andreas Joseph Krogh CTO / Partner
 - Visena AS Mobile: +47 909 56 963 andreas@visena.com 
<mailto:andreas@visena.com> www.visena.com <https://www.visena.com>  
<https://www.visena.com>
[Attachment #7 (text/html)]

<div>På torsdag 26. september 2019 kl. 00:53:28, skrev Tom Lane &lt;<a \
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;:</div>

<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt \
0.8ex; padding-left: 1ex;"> <div style="display:inline; font-family: monospace; \
font-size: 12px;">Andreas Joseph Krogh &lt;andreas@visena.com&gt; writes:<br> &gt; \
Can anybody shed som light<br> &gt; on when negative-prefix is supposed to be \
respected by PG's<br> &gt; formatting-functions? In lc_numeric='nb_NO.UTF-8' \
negative-prefix is '−'(8722),<br> &gt; not '-'(45), at least in the JAVA-world, but \
it seems the JDBC-driver must use<br> &gt; lc_numeric='C' when parsing server output. \
-- Andreas Joseph Krogh CTO / Partner<br> <br>
PG does not consider LC_NUMERIC at all when producing output from<br>
the standard numeric data types (and we aren't going to start).<br>
AFAIR the only functions that do pay attention to LC_NUMERIC are<br>
to_char() and friends.<br>
<br>
regards, tom lane</div>
</blockquote>

<div>  </div>

<div>  </div>

<div>Thanks for clarifying.</div>

<div>  </div>

<div class="visena-email-signature" \
data-visena-message-id="&lt;VisenaEmail.2.ca0eeb68bbbb2fc3.16d6aa6a359@tc7-visena>"> \
<div>-- <div><span style="font-family:arial,helvetica,sans-serif;"><strong>Andreas \
Joseph Krogh</strong></span></div>

<div><span style="font-family:arial,helvetica,sans-serif;">CTO / Partner</span> - \
Visena AS</div>

<div><span style="font-family:arial,helvetica,sans-serif;">Mobile: +47 909 56 \
963</span></div>

<div><a href="mailto:andreas@visena.com">andreas@visena.com</a></div>

<div><a href="https://www.visena.com">www.visena.com</a></div>

<div style="padding-top: 5px"><a href="https://www.visena.com"><img alt="" \
src="cid:part_F596026880274TTOW0U"></a></div> </div>
</div>

<div>  </div>


[Attachment #8 (image/png)]

[prev in list] [next in list] [prev in thread] [next in thread]