In web2py, distinct can be boolean (distinct=True) or an expression, as quoted from the book. Boolean works fine, but expression maps to DISTINCT ON.
It is in BaseAdapter class, _select method. I think only nosql adapters override that method. Marin (mobile) On Mar 8, 2013 4:48 PM, "Richard Vézina" <[email protected]> wrote: DISTINCT and DISTINCT ON are two differents things : http://www.postgresql.org/docs/9.1/static/sql-select.html#SQL-DISTINCT I think that this is a issue with differents adaptors... And you maybe right that DISTINCT ON is only available on postgres... Richard On Fri, Mar 8, 2013 at 5:31 AM, Marin Pranjić <[email protected]> wrote: > > A quote from t... -- --- 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.
