func.XXX just renders XXX(). If you use Postgresql, you have the statisical aggregate function "variance":
http://www.postgresql.org/docs/7.1/static/functions-aggregate.html mysql has it too: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html both above would be rendered via func.variance() for databases that don' t have built in stats aggregate functions, typically a stored procedure or database function can be created that performs the std dev calculations. On Sep 3, 2010, at 2:45 AM, sajuptpm wrote: > How calculate variance in sqlalchemy > No function func.variance() in sqllalchemy > > -- > 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. > -- 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.