[R-sig-DB] Data type error with RpgSQL on Windows XP SP3 32bit

[Xiaobo Gu]

It works too, but the original problem still occurs.

con <- dbConnect(pgSQL(classPath="D:\\rtemp\\postgresql-8.4-702.jdbc4.zip"))
> ct <- 'CREATE TABLE DF ("a" INTEGER, "b" VARCHAR(255), "c" DATE,"d" DOUBLE
PRECISION)'
>  dbSendUpdate(con, ct)
>
> DF <- data.frame(a = 1L, b = "Hello", c = Sys.Date(), d = 32)
> dbSendUpdate(con, "insert into DF values(1, 'Hello', to_date('2000-01-01',
'YYYY-MM-DD'), 32)")
> res <- dbGetQuery(con, "select * from DF")
> res
  a     b          c  d
1 1 Hello 2000-01-01 32
> str(res)
'data.frame': 1 obs. of  4 variables:
 $ a: num 1
 $ b: Factor w/ 1 level "Hello": 1
 $ c:Class 'Date'  num 10957
 $ d: num 32
>

On Mon, Nov 1, 2010 at 10:33 AM, Gabor Grothendieck <ggrothendieck using gmail.com
> wrote:

> On Sun, Oct 31, 2010 at 10:17 PM, Xiaobo Gu <guxiaobo1982 using gmail.com>
> wrote:
> > Hi,
> > What's the versions for all the related components, R, DBI, rJava,RJDBC,
> > RpgSQL, PostgreSQL JDBC?
> >
>
> I am using the most recent versions of all packages and R 2.11.1
> Patched on Windows Vista:
>
> > packageDescription("RJDBC")$Version
> [1] "0.1-5"
> > packageDescription("DBI")$Version
> [1] "0.2-5"
> > packageDescription("rJava")$Version
> [1] "0.8-7"
> > packageDescription("RpgSQL")$Version
> [1] "0.1-3.2"
> > R.version.string
> [1] "R version 2.11.1 Patched (2010-05-31 r52167)"
> > win.version()
> [1] "Windows Vista (build 6002) Service Pack 2"
>
> The Windows binary of rJava seems currently not to be available on CRAN:
> http://cran.r-project.org/web/packages/rJava/index.html
> but you can build it yourself or get it from R-Forge.
>
> Did you try running the reproducible example in my email?  Did it work for
> you?
>
> --
> Statistics & Software Consulting
> GKX Group, GKX Associates Inc.
> tel: 1-877-GKX-GROUP
> email: ggrothendieck at gmail.com
>



On Mon, Nov 1, 2010 at 10:33 AM, Gabor Grothendieck <ggrothendieck using gmail.com
> wrote:

> On Sun, Oct 31, 2010 at 10:17 PM, Xiaobo Gu <guxiaobo1982 using gmail.com>
> wrote:
> > Hi,
> > What's the versions for all the related components, R, DBI, rJava,RJDBC,
> > RpgSQL, PostgreSQL JDBC?
> >
>
> I am using the most recent versions of all packages and R 2.11.1
> Patched on Windows Vista:
>
> > packageDescription("RJDBC")$Version
> [1] "0.1-5"
> > packageDescription("DBI")$Version
> [1] "0.2-5"
> > packageDescription("rJava")$Version
> [1] "0.8-7"
> > packageDescription("RpgSQL")$Version
> [1] "0.1-3.2"
> > R.version.string
> [1] "R version 2.11.1 Patched (2010-05-31 r52167)"
> > win.version()
> [1] "Windows Vista (build 6002) Service Pack 2"
>
> The Windows binary of rJava seems currently not to be available on CRAN:
> http://cran.r-project.org/web/packages/rJava/index.html
> but you can build it yourself or get it from R-Forge.
>
> Did you try running the reproducible example in my email?  Did it work for
> you?
>
> --
> Statistics & Software Consulting
> GKX Group, GKX Associates Inc.
> tel: 1-877-GKX-GROUP
> email: ggrothendieck at gmail.com
>

	[[alternative HTML version deleted]]