PostgreSQL 10 pagination

Example:

select * from test limit 2 offset 2;

Limit: How many data are checked
Offset: Starting from the subscript, the subscript starts at 0 and cannot be a negative number.
Offset Calculation formula:

var offset=(pageIndex-1) * pageSize // pageIndex must be greater than 0

Note: Limit and offset do not need to exist at the same time (this is more interesting)

1. Check the first 2 data

Specify limit, no offset specified, default offset=0

select * from test limit 2;

2. Skip the previous 2 data to check all the data behind

Specifies offset, without specifying limit,limit= infinity or No

select * from test offset 2;

select * from test offset 0;  / * Check all data, equivalent to select * from test * /

PostgreSQL 10 pagination