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
-
-
sorry, haven't worked through the details, but.. order by / where apply to original rows, group by / having apply to an aggregate function over that result. So presumably you can have a bistable function that is true once your condition is seen..
-
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
- 4 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.