3 ms·
Yes, if you want to support new records being added it's up to you to include something like a created date as part of your specified sort order. More than pag
by simonw 4y ago
Yes, if you want to support new records being added it's up to you to include something like a created date as part of your specified sort order.
More than page_size records with that value works fine - that's why the primary key is included as a tie-breaker.
- erikpukinskis 4y agoDoesn’t that take you back to the original problem though: if you delete the primary key the query fails? Would the created_at be a better option than the primary key? That can’t be deleted or changed, and that would give you a stable secondary sort?