tests/testthat/test-bigint.R

In RPostgres: C++ Interface to PostgreSQL

test_that("integer", {
  con <- postgresDefault(bigint = "integer")
  on.exit(dbDisconnect(con))

  expect_identical(dbGetQuery(con, "SELECT COUNT(*) FROM (SELECT 1) A")[[1]], 1L)
})

test_that("numeric", {
  con <- postgresDefault(bigint = "numeric")
  on.exit(dbDisconnect(con))

  expect_identical(dbGetQuery(con, "SELECT COUNT(*) FROM (SELECT 1) A")[[1]], 1.0)
})

test_that("character", {
  con <- postgresDefault(bigint = "character")
  on.exit(dbDisconnect(con))

  expect_identical(dbGetQuery(con, "SELECT COUNT(*) FROM (SELECT 1) A")[[1]], "1")
})