db.result.get.value {RPgSQL}R Documentation

Fetch a value from returned tuples

Description

db.result.get.value() returns values contained in tuples that resulted from the last query.

Usage

db.result.get.value(row=1, col=1)

Arguments

row The row number
col The column number

Value

The value of the tuple.

Note

Row and column numbers are always 1-based

Author(s)

Timothy H. Keitt

See Also

db.execute, db.result.rows, db.result.columns

Examples

if (db.connection.open()) {
  db.execute("select usename, usesysid from pg_user", clear=F);
  row <- db.result.rows();
  col <- db.result.columns();
  cat("Value at last row and column is",
    db.result.get.value(row=row, col=col), "\n")
  db.clear.result()
}