Back to formatted view
Raw Message

Message-ID: <4DE53D51.10401@gmail.com>
Date: 2011-05-31T19:11:13Z
From: Dinesh
Subject: dbGetQuery and options(stringsAsFactors=F)

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