Luis Mariano Luporini wrote:
Chris:
That is the code I'm having problems with.
I know, that's why I asked you to supply it so we can take a look and help you!
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.
The DA is probably turning the returned number into a python Float, the default representation of which has one decimal place.
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.
Then you'd get a string ;-) Most people want numbers when they select numeric columns from relational databases... Chris