Using the ResultSet Interface

The following must be considered when using the ResultSet interface:

  • Before reading any values, you must call next(). This returns true if there is a result, but more importantly, it prepares the row for processing.
  • You must close a ResultSet by calling close() once you have finished using it.
  • Once you make another query with the Statement used to create a ResultSet, the currently open ResultSet instance is closed automatically.
Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group