Re: [GENERAL] Question about row_number() ordering semantics

2014-09-24 Thread Tom Lane
Fred Jonsson writes: > As I was playing around with `row_number()`s for cursor-based pagination, I > came across some ordering behavior that I didn't expect. > In particular, when I order in a way where multiple rows compete for the > same position in the result set (i.e., rows that are equivalen

[GENERAL] Question about row_number() ordering semantics

2014-09-24 Thread Fred Jonsson
Hey everyone, As I was playing around with `row_number()`s for cursor-based pagination, I came across some ordering behavior that I didn't expect. In particular, when I order in a way where multiple rows compete for the same position in the result set (i.e., rows that are equivalent in terms of t