A quote from the book:
Notice that distinct can also be an expression for example: > >>> for row in db().select(db.person.name,distinct=db.person.name): > print row.name > Alex > Bob > Carl > > > > While this works on PostgreSQL, others raise an exception. OperationalError: near "ON": syntax error This is what I get on SQLite. It makes sense because 'DISTINCT ON' is only supported by Postgres (correct me if I'm wrong). Do we need this in the book? -- --- 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.
