Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13760: order by . offset .. limit bug? when order by column has same value - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #13760: order by . offset .. limit bug? when order by column has same value
Date
Msg-id 26690.1447087768@sss.pgh.pa.us
Whole thread Raw
In response to BUG #13760: order by . offset .. limit bug? when order by column has same value  (digoal@126.com)
List pgsql-bugs
Tree view 
digoal@126.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 about
the ordering of rows with equal keys.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Hiep Pham
Date:
Subject: connect to C program
Next
From: "Shulgin, Oleksandr"
Date:
Subject: Re: connect to C program