PostgreSQL – repeating rows from LIMIT OFFSET
Why does “foo” appear in both queries? Because all rows that are returned have the same value for the status column. In that case the database is free to return the rows in any order it wants. If you want a reproducable ordering you need to add a second column to your order by statement … Read more