On 07/30/2013 03:03 AM, Ingmar Brouns wrote:
On Mon, Jul 29, 2013 at 3:12 PM, Ingmar Brouns <[email protected]> wrote:
anyone? Giving a locale corresponding textual representation
of a numerical value keeping the exact nr of decimal digits
must be a fairly common use case. Would it be an idea to
implement a to_char function that does not take a formatting
pattern and has this behaviour?
Best I can do is a proof of concept in plpythonu for determining locale
decimal point:
test=# SHOW lc_numeric ;
lc_numeric
-------------
en_US.UTF-8
(1 row)
test=# DO $$
import locale
rs = plpy.execute("SHOW lc_numeric")
lc_n = rs[0]["lc_numeric"]
locale.setlocale(locale.LC_NUMERIC, lc_n)
d = locale.nl_langinfo(locale.RADIXCHAR)
plpy.notice("Decimal point is " + d)
$$ LANGUAGE plpythonu;
NOTICE: Decimal point is .
CONTEXT: PL/Python anonymous code block
DO
test=# set lc_numeric = 'nl_NL.utf8';
SET
test=# DO $$
import locale
rs = plpy.execute("SHOW lc_numeric")
lc_n = rs[0]["lc_numeric"]
locale.setlocale(locale.LC_NUMERIC, lc_n)
d = locale.nl_langinfo(locale.RADIXCHAR)
plpy.notice("Decimal point is " + d)
$$ LANGUAGE plpythonu;
NOTICE: Decimal point is ,
CONTEXT: PL/Python anonymous code block
DO
I would like to have '1,500' as the output, what is the best way
to achieve this?
Thanks in advance,
Ingmar
--
Adrian Klaver
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
