dbGetQuery and options(stringsAsFactors=F)
On Tue, May 31, 2011 at 3:11 PM, dinesh <dinesh.k.somani at 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