Postgres to R date conversion and Writing NULL to postgres database using RpgSQL issue

On Thu, Apr 21, 2011 at 6:32 AM, subodh agrawal <subodh.iitr at gmail.com> wrote:

Please comment on thses two queries.

1) While converting field of data type "date" selected form postgres,
RpgSQL gives error on windows ?when field value is null.

Thanks. ?This reproduces the error.

library(RpgSQL)
DF <- data.frame(a = c(1, NA, 2), b = c(Sys.Date() + 1:2, NA), c =
c("a", NA, "b"))
con <- dbConnect(pgSQL(), user = "whatever", password = "whatever",
dbname = "whatever")
dbWriteTable(con, "DF", DF)