[Zope] Extrange behavior with numeric datatypes and decimal places

[Luis Mariano Luporini]

Chris:

        That is the code I'm having problems with. If I run that in 
psql, I get the number of decimal places specified by the numeric 
casting but, if I run it in a zsql I get just un decimal place 
regardless of what is specified in the cast operation.

        As suggested by Neil Smith in the zope-db list I could use a 
formating mask in dtml or zpt but I think that default behavior should 
be to left the query as it is.

        Thanks for your reply.

Luis.

       

Chris Withers wrote:

> Luis Mariano Luporini wrote:
>
>> I've put "select 3::numeric(10,2)" in a zsql method, in a zpt that 
>> calls that method 
>
>
> This is the code you want to fix. What is the code you currently have?
>
> Chris
>