Propose this to web2py developers. The main problem is that not all backends support it but mysql and postgresql do and we do not usually support non-portable syntax.
On Tuesday, 15 November 2016 14:10:29 UTC-6, Brendan Barnwell wrote: > > I notice that the pydal Expression class defines magic methods for most > math operations, letting you create expression queries like > `.select(db.Table.field*2)`. However, it doesn't define a __pow__ method, > so I can't do something like `.select(db.Table.field**2)` to get a computed > result that is the square of some field. Is there a reason for this? I'd > like to be able to make such queries. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.

