The following bug has been logged online:
Bug reference: 6144
Logged by: Eduard Kracmar
Email address: eduard.kracmar@gmail.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).