Hi all,
I'm having a problem with LIMITed queries, and I don't know is it me who
is doing something wrong or Postgres. (Probably me.)
When I browse through the list of employees:
id id_dept name
-------------------
1 1 Tom
2 1 Mike
3 2 Meggie
4 2 Marge
5 3 Bart
6 3 Lisa
7 4 Homer
using LIMITed selects like:
SELECT * FROM employee ORDER BY id_dept LIMIT 3
SELECT * FROM employee ORDER BY id_dept LIMIT 3 OFFSET 3
SELECT * FROM employee ORDER BY id_dept LIMIT 3 OFFSET 6
it seems that Meggie is not in the result list on any of the SELECTs.
From the first query I get Tom, Mike and Marge, and then from the
second Marge, Bart and Lisa.
Is this expected behavior?
My configuration is: CentOS 5.3 and Postgres 8.3.7.
Regards,
Ognjen