tests/testthat/test-bigint.R

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")
})

Try the RPostgres package in your browser

Any scripts or data that you put into this service are public.

RPostgres documentation built on May 29, 2024, 3:12 a.m.