[web2py] Re: How do you define a column name on summed field (i.e. how to do the equivalent of an sql 'select ..... as colname'

[Anthony]

>
> I am not convinced that 
>
> rows = db().select(db.table.field1.sum() as foo) 
> +  {{=row.foo}} 
>
> is any simpler than 
>
> foo = db.table.field1.sum() 
> rows = db().select(foo) 
> +  {{=row[foo]}}
>

The problem is in the latter case, you have to pass foo to the view -- not 
a big deal with just foo, but more cumbersome with multiple expressions.

Anthony