[R] RODBC and NULL values

[Mark Wardle]

Mark Wardle wrote:
> Dear all,
> 
> I'm afraid I'm still having trouble with RODBC and NULL values on Mac OS
> ... <snip>
> limited to RODBC, and is not an ODBC driver problem? Any ideas? I'll be
> switching to RdbiPgSQL from now, but I thought it appropriate to flag
> this up as an unsolved problem.

Hmmm.. there are several issues with RdbiPgSQL (including not doing as
good a job at recognising factors for example - this requires manually
checking data frames returned, and fixing data types with liberal use of
as.factor() etc..), so if anyone has information on the best way to
access PostgreSQL from R, then all advice appreciated!

Apart from the NULL value problem, RODBC seems the best and most mature
and does a great job of inferring data types.  The RPGSQL website
suggests it is abandoned in favour of Rdbi, Rdbi's website suggests it
is abandoned in favour of DBI. This doesn't complete support postgresql
as far as I can see, but they recommend the RdbiPgSQL package on
bioconductor as above.

Thanks,

Mark


-- 
Dr. Mark Wardle
Clinical research fellow and Specialist Registrar in Neurology,
C2-B2 link, Cardiff University, Heath Park, CARDIFF, CF14 4XN. UK
email: wardle at cardiff.ac.uk  mark at wardle.org   OpenPGP key: 66896A39
office: +44(0)2920743454 facsimile: +44(0)2920743798
mob: +44(0)7786196137 home: +44(0)2920216341