Set with all rows for web2py / pydal

Question

In web2py I can do the following:

rows = db().select(person.ALL)

Which gives me all rows in the database person.

I can also do:

myset = db(person.name == 'Jim')

Which gives me a set of all people named Jim.

How can I get a set of all people?

Answer 1

For a Set object defining all the records in the table, you can do:

db(db.person)

which is equivalent to:

db(db.person.id > 0)