digoal(at)126(dot)com writes:> when order by column has same values, there will return (0,1) all times> whatever offset x.
I don't see any bug here. ORDER BY does not promise anything aboutthe ordering of rows with equal keys.
regards, tom lane