not displaying first row in results
Brought to you by:
jparrai
Eclipse 3.3, Quantum 3.3 against postgres 8.3. I have a table with 4 simple columns. If I open the table directly by double clicking, or issue a query such as, "Select * from tablname" The first row in the result set is missing from the display. If I query the table for that individual row, it will display in the results, but if it is part of a larger result, it is not shown in the list.
Logged In: YES
user_id=180901
Originator: NO
That's mighty strange. I certainly cannot duplicate it, even if I haven't tried it with postgres yet. Could you try it with another database, to see if it's database-dependent? If you installed the Derby plugin in the Quantum distribution, just open the "(internal) Derby" bookmark and click on one of the sample tables to see if all the records (they are numbered so it's easy to see) are there.
Thanks for your feedback
Logged In: YES
user_id=1173633
Originator: YES
I think it's just me being stupid. Sorry to waste your time. I see now that my result is larger than can fit on the page of returned results (200). While it appears to be ordered by the id, it wasn't explicitly ordered by the id, so it could just be the way the database is returning the results. If I query and explicitly order by the id, the row shows up in the appropriate place. Thanks, and again, I'm sorry for wasting your time on this.
Logged In: YES
user_id=180901
Originator: NO
No problem :o)