that syntax (orderby positional arguments) should work in any relation db, it's standard t-sql.
On Tuesday, September 3, 2013 9:40:52 PM UTC+2, Michele Comitini wrote: > > Given: > > SELECT t1.t1_f1, max(t2.t2_f1) FROM t1 JOIN t2 on t1.id = t2.t1_id GROUP > BY t1.t1_f1 ORDER BY max(t2.t2_f1), t1.t1_f1; > > > If I recall correctly in PostgreSQL you can do: > > SELECT t1.t1_f1, max(t2.t2_f1) FROM t1 JOIN t2 on t1.id = t2.t1_id GROUP > BY 1 ORDER BY 2,1; > > > i.e. you can use the positional arguments in place of the expressions. > > -- --- 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/groups/opt_out.
