I really wish a function existed in PG that took some order by clause and gave a value with comparator functions... I'll hopefully write a blog post about this in the next few days. Or I'll get sidetracked writing bg info on btrees and why offset is bad and never finish
That's not really helpful here, this is for seeking in a pagination context. E.g. turning `ORDER BY ... LIMIT X OFFSET Y` into a where clause only for records appearing after OFFSET Y
-
-
oh.. something with cursors, probably where your function returns the cursor?
-
Yeah cursor based pagination is one term folks use to describe this. Using actual sql cursors for this uses more resources than the problem it's solving though
- 2 more replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.