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
-
-
Show this thread
-
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.