The following bug has been logged online:
Bug reference: 6144
Logged by: Eduard Kracmar
Email address: [email protected]
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).
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs