6.2.6 #:limit and #:offset clauses

LIMIT in PostgreSQL

The #:limit and #:offset clauses allow you to choose how many results you wish to receive and where in the result set you wish to retrieve them from. Each can be a natural number or #f, where #f is equivalent to omitting the clause.

← prev up next →

1	Quick start
2	Snooze modules
3	Persistent structures
4	Entities, relationships and attributes
5	Connecting to, querying and updating databases
6	Queries
7	Quick find procedures
8	Acknowledgements

6.1	Query methods/ procedures
6.2	Query syntax

6.2.1	Data sources, result types and the #: from clause
6.2.2	The #: what clause
6.2.3	The #: where clause
6.2.4	The #: order clause
6.2.5	#: group and #: having clauses
6.2.6	#: limit and #: offset clauses
6.2.7	The #: distinct clause
6.2.8	Aliases
6.2.9	Procedural query layer