fetch-methods

0th

Percentile

Fetch records from a previously executed query

This method is a straight-forward implementation of the corresponding generic function.

Keywords
methods, interface, database
Details

The RPostgreSQL implementations retrieves only n records, and if n is missing it only returns up to fetch.default.rec as specified in the call to PostgreSQL (500 by default).

Methods

res

an PostgreSQLResult object.

n

maximum number of records to retrieve per fetch. Use n = -1 to retrieve all pending records; use a value of n = 0 for fetching the default number of rows fetch.default.rec defined in the PostgreSQL initialization invocation.

currently not used.

References

See the Database Interface definition document DBI.pdf in the base directory of this package or https://cran.r-project.org/package=DBI.

See Also

PostgreSQL, dbConnect, dbSendQuery, dbGetQuery, dbClearResult, dbCommit, dbGetInfo, dbReadTable.

Aliases
  • fetch-methods
  • fetch,PostgreSQLResult,numeric-method
  • fetch,PostgreSQLResult,missing-method
Examples

Documentation reproduced from package RPostgreSQL, version 0.6-2, License: GPL-2 | file LICENSE

Community examples

Looks like there are no examples yet.