On Sun, Mar 22, 2009 at 12:39 PM, Michael Bayer <mike...@zzzcomputing.com>wrote:

>
>
> On Mar 22, 2009, at 3:00 PM, Shawn Church wrote:
>
> >
> > This isn't really the same thing because the float would be rounded
> > after the sum not line by line.  I think I could also use sum(...
> > type_ = Numeric(14,2)) for the same result.  Am I missing an easier
> > way to do this?
>
> its an SQLA bug that will require a workaround until 0.6.  another
> approach is monkeypatching a get_col_spec() on your Numeric type:
>
> n = Numeric(14, 2)
> n.get_col_spec = lambda: "NUMERIC(14, 2)"
>
> that will work throughout 0.5.  in 0.6 it will not be needed but also
> have no effect.
>
>
Thanks,  this seems a reasonable workaround.  But would I cast(..., n)?

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to