monetary bug
От | Mahmoud Taghizadeh |
---|---|
Тема | monetary bug |
Дата | |
Msg-id | 20040822115033.96353.qmail@web50710.mail.yahoo.com обсуждение исходный текст |
Ответ на | Compilation problems and extension on Windows (Shachar Shemesh <psql@shemesh.biz>) |
Ответы |
NLS support for postgreSQL
Re: monetary bug |
Список | pgsql-hackers |
I found a little bug in monetary function of postgresql function cash_in in file cash.c the problem is that when I run set lc_monetary to "fa_IR.UTF8" and try to insert a value to a field with type of money, I got the following error: "invalid input syntax for type money: "1000" at the same time when I run "set lc_monetary to "en_US.UTF8", everythings worked well. I studied the source code and I found that cash.c has a little problem to handling money type. I found that this bug exists for all of countries that have not precision for their money. I decided to write a patch for this bug, but before I start my work, i want to know if anyone has any idea about this bug or not? a dirty method to fix this bug is to replace following line if (isdigit((unsigned char) *s) && dec < fpoint ) with if (isdigit((unsigned char) *s) && ((dec < fpoint) || fpoint == 0)) M, Taghizade Regards __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
В списке pgsql-hackers по дате отправления: