[R-sig-DB] dbGetQuery and options(stringsAsFactors=F)

Gabor Grothendieck ggrothend|eck @end|ng |rom gm@||@com
Tue May 31 22:12:08 CEST 2011


On Tue, May 31, 2011 at 3:11 PM, dinesh <dinesh.k.somani using gmail.com> wrote:
> 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
>

There is no such option but in the development version the default is
FALSE.  I can send it to you offline.

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com




More information about the R-sig-DB mailing list