id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 2150 slicing to the end of a QuerySet Gary Wilson nobody "Currently, when trying to slice to the end of a QuerySet, an AssertionError is raised: {{{ #!python >>>Foo.objects.all()[3:] Traceback (most recent call last): File """", line 1, in ? File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"", line 88, in __repr__ return repr(self._get_data()) File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"", line 412, in _get_data self._result_cache = list(self.iterator()) File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"", line 162, in iterator select, sql, params = self._get_sql_clause() File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"", line 490, in _get_sql_clause assert self._offset is None, ""'offset' is not allowed without 'limit'"" AssertionError: 'offset' is not allowed without 'limit' }}} However, returning rows from an offset to the end of a result set does seem possible... '''in MySQL (>=3.23)''' ''""To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:""'' http://dev.mysql.com/doc/refman/4.1/en/select.html {{{ #!sql SELECT * FROM tbl LIMIT 95,18446744073709551615; }}} '''and in PostgreSQL (>=7.3)''' ''""LIMIT ALL is the same as omitting the LIMIT clause.""'' http://www.postgresql.org/docs/7.3/static/queries-limit.html {{{ #!sql SELECT select_list FROM table_expression [LIMIT { number | ALL }] [OFFSET number] }}}" enhancement closed Database layer (models, ORM) dev normal fixed qs-rf-fixed gary.wilson@… ferringb@… Accepted 0 0 0 0 0 0