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? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bjørn T Johansen btj@xxxxxxxxxx ----------------------------------------------------------------------------------------------- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" ----------------------------------------------------------------------------------------------- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
