pagination-done-right.sql

create table foo (
  id bigserial primary key,
  name text,
  created date
);

insert into foo(name,created) values
  ('lol', '2018-01-09'),
  ('lol', '2018-01-08'),
  ('lol', '2018-01-08'),
  ('wow', '2018-01-07'),
  ('wow', '2018-01-09'),
  ('lol', '2018-01-09');
  
  
select * from foo order by name, id LIMIT 2;

select * from foo where id>2 OR name!='lol' order by name, id LIMIT 2;

select * from foo where id>6 OR name!='lol' order by name, id LIMIT 2;

so the idea is to add id at the end of your order by columns, and then for next page use the starting condtion id>lastId OR col!=lastColValue