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
Writing a where clause that is "rows that appear after the row with a given id" for an arbitrary order by clause in generic code is possible, but obnoxiously hard. Especially once you start assuming all columns can contain null and handling nulls first/last
-
-
I can't be the first person to want to do this. And this feels like the sort of thing that PG has hidden gems to help with, but I can't seem to find them.
Show this thread -
Anyway I guess this is also me announcing my upcoming library to handle seek based pagination for arbitrary order by clauses >_>
Show this thread
End of conversation
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.