PostgreSQL: find sequences of same-parameter values within ordered groups
Using a window function find and group consecutive occurences of the values with the same paratemer
PostgreSQL: update by spliting result set into evenly sized chunks using window function
How do you update result set by spliting it into evenly sized chunks using window function row_number()