I have the following Java code:
---snip---
ResultSet rst = pgConnection.openResultSet("SELECT foo, bar from
table1");
while (rst.next))
System.out.println(rst.getString("foo"),
rst.getString("bar"));
---snip---
[I'm writing from memory - not sure if openResultSet is the correct method
name.]
This always only prints _one_ record, which is also the last record. The
docs say that the cursor opens before the first record, so I must be doing
something wrong.
I am using PostgreSQL 6.5 database (yes, I know it's old, but I'm only
playing/learning/prototyping/...) Surely, this is not a pg6.5 problem? Or is
it?
I'd appreciate any pointers.
TIA
Stoffel van Aswegen
import signature.*;