> > I have the following sql: > > SELECT * from table order by dato asc limit 20 offset 0 > > > This gives me different rows than the 20 first rows when running the > following sql: > > SELECT * from table order by dato asc > > > Shouldn't the 20 first rows in the second sql statment be the same 20 > rows that is returned in the first statement > or am I missing something? >
Not necessarily. In your example query, if "dato" was not a unique column, and there were some duplicates, the "top 20" values is not a defined set. Adding the offset clause might cause a different query plan, resulting in a different ordering of the duplicate values. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
