Same behavior with 0.6.3. On Aug 3, 4:17 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > On Aug 3, 2010, at 5:00 PM, Bryan wrote: > > > Python 2.5.4 > > MySQL python 1.2.3c1 > > sqlalchemy 0.5.2 > > just curious can you try with SQLA 0.6.3 ? > > > > > Here is the actual code. It references my object model etc so it > > won't run for you, but just in case I made a mistake converting it to > > a simplified version of the problem here it is: > > > dollars = func.if_(EmpTime.actTotal != None, EmpTime.actTotal, > > EmpTime.estTotal, type_=types.Numeric) > > q = orm.query( > > Account.code, > > func.lower(TimeType.shortName), > > func.sum(EmpTime.hours), > > func.sum(dollars, type_=types.Numeric) > > ) > > q = q.join(EmpTime.acc).join(EmpTime.timeType) > > q = q.group_by(Account.code).group_by(TimeType.shortName) > > q = q.filter(EmpTime.day >= start) > > q = q.filter(EmpTime.day <= end) > > q = q.filter(EmpTime.jobId == jobId) > > labor = q.all() > > > On Aug 3, 1:26 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > >> On Aug 3, 2010, at 2:56 PM, Bryan wrote: > > >>> This returns a Decimal type for c2, which is what I want: > >>> c1 = literal(5, type_=Numeric) > >>> c2 = func.sum(c1, type_=Numeric) > > >>> This returns a Float type for c2, but I'm telling c1 that it is a > >>> Numeric. How can I get a decimal returned when using an if function? > >>> c1 = func.if_(Table.foo != None, Table.foo, Table.bar, type_=Numeric) > >>> c2 = func.sum(c1, type_=Numeric) > > >> I see nothing wrong with that code. Can I get some SQLA version / > >> database backend / DBAPI details ? > > >>> -- > >>> You received this message because you are subscribed to the Google Groups > >>> "sqlalchemy" group. > >>> To post to this group, send email to sqlalch...@googlegroups.com. > >>> To unsubscribe from this group, send email to > >>> sqlalchemy+unsubscr...@googlegroups.com. > >>> For more options, visit this group > >>> athttp://groups.google.com/group/sqlalchemy?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "sqlalchemy" group. > > To post to this group, send email to sqlalch...@googlegroups.com. > > To unsubscribe from this group, send email to > > sqlalchemy+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/sqlalchemy?hl=en.
-- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.