From: | "Eduard Kracmar" <eduard(dot)kracmar(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6144: Postgres ignores locale's p_cs_precedes and n_cs_precedes settings |
Date: | 2011-08-03 12:47:47 |
Message-ID: | 201108031247.p73CllZh012204@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 6144
Logged by: Eduard Kracmar
Email address: eduard(dot)kracmar(at)gmail(dot)com
PostgreSQL version: 8.4.8
Operating system: Debian/testing
Description: Postgres ignores locale's p_cs_precedes and
n_cs_precedes settings
Details:
I'm using sk_SK.utf8 locales on Debian/testing. Running postgresql 8.4.8 and
it ignores p_cs_precedes and n_cs_precedes settings in
/usr/share/i18n/locales/sk_SK. Euro sign should follow monetary quantity.
As tested in PHP for example, it works as it should:
$number = 1234.567;
setlocale(LC_MONETARY, 'sk_SK.utf8');
echo money_format('%n', $number); // 1 234,57 €
But in postgres while using money data type with lc_monetary set to
'sk_SK.utf8', € sign is before figure:
€123,45
Also, displaying monetary quatity bigger than 999 gives null, compared to
de_DE.utf8 which gives correct formatting: €1.234,56 (except for euro sign
of course, as mentioned before).
From | Date | Subject | |
---|---|---|---|
Next Message | simon.marshall | 2011-08-03 15:02:20 | Postgres running but no postmaster.pid |
Previous Message | Snehad Agrekar | 2011-08-03 11:34:18 | BUG #6143: connection problem |