4 Aug
2003
4 Aug
'03
3:48 a.m.
Hi list. I'm having a problem using the following: - Gentoo Linux - Zope 2.6.1 - Python 2.1.3 - psycopg 1.1.2 - zpsycopgda 1.1.2 - Postgresql 7.3.3 The situation is I'm trying to get a number (result of a division) rounded to two decimal places and can't get it to work. After some research, my problem can be simplified to this: If I run the query: select 3::numeric(10,2) in psql I get a result of 3.00 (normal and expected behavior) in zope I get a result of 3.0 (why just one decimal place?) How can I get around this. Is this a bug in psycopg or something like that? Anybody experienced this? Thanks in advance.