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.

Reply via email to