[R-sig-DB] dbGetQuery and options(stringsAsFactors=F)
dinesh
d|ne@h@k@@om@n| @end|ng |rom gm@||@com
Tue May 31 21:11:13 CEST 2011
Is there some configuration to make dbGetQuery() pick up defaults set
via options() call? E.g.,
require(RpgSQL);
options(stringsAsFactors=F);
...
x=dbGetQuery(dbConnect(pgSQL()), "select * from some_table");
is.factor(x[1,"stringcol"]) # returns TRUE
#OTOH
x=dbGetQuery(dbConnect(pgSQL()), "select * from
some_table",stringsAsFactors=F);
is.factor(x[1,"stringcol"]) # returns FALSE
I am using RpgSQL 0.1-5 with RJDBC 0.2.
--
Regards,
Dinesh
More information about the R-sig-DB
mailing list