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'm still stuck on why something like this doesn't work to filter out / skip ahead to what you want.. select id, a, b, c, have_seen(I ,id) as seen from foo order by blah group by id,a,b,c having seen == true
-
That would work, but has the same issues as offset, as it's re-implementing the same fundamental behavior
- 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.