[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