[R-sig-DB] Data type error with RpgSQL on Windows XP SP3 32bit
Xiaobo Gu
gux|@obo1982 @end|ng |rom gm@||@com
Sun Oct 31 10:39:09 CET 2010
Hi,
Can you help with this
> driver<-pgSQL(classPath="D:\\rtemp\\postgresql-9.0-801.jdbc4.zip")
> con <- dbConnect(driver, user="postgres", password="postgres",
dbname="demo")
> con
An object of class "pgSQLConnection"
Slot "jc":
[1] "Java-Object{org.postgresql.jdbc4.Jdbc4Connection using 1ce2dd 4}"
Slot "identifier.quote":
[1] "\""
> data <- dbGetQuery(con, "select * from optest.colana")
Error as.Date.default(.jcall(res using jr, "S", "getString", i)) :
do not know how to convert '.jcall(res using jr, "S", "getString", i)' to class
"Date"
>
the DDL is :
CREATE TABLE optest.colana
(
a integer,
b character varying(12),
c date,
d numeric
)
[[alternative HTML version deleted]]
More information about the R-sig-DB
mailing list