Question: [PATCH] apparent bug in RdbiPgSQL (logicals always false)
0
gravatar for Mitchell Skinner
15.6 years ago by
Mitchell Skinner40 wrote:
Hello, For me, using RdbiPgSQL, logical columns in the result of a dbGetQuery contain only false values, even if the database rows contain true values (statgen is an open connection to a PostgreSQL database): > dbGetQuery(statgen, "SELECT true;") bool 1 FALSE RdbiPgSQL versions: 1.0.2, 1.0.5 Postgres client lib versions: postgresql-libs-7.4.1-1PGDG, postgresql-libs-7.3.4-11 Postgres server version: postgresql-7.4.1-1PGDG The attached patch appears to solve the problem for me. With the patch applied: > dbGetQuery(statgen, "SELECT true;") bool 1 TRUE I'm assuming that the BioConductor list is the place to send this, since I got RdbiPgSQL from BioConductor in the first place. If not, please point me in the right direction. Regards, Mitch -------------- next part -------------- A non-text attachment was scrubbed... Name: RdbiPgSQL.diff Type: text/x-patch Size: 348 bytes Desc: not available Url : https://www.stat.math.ethz.ch/pipermail/bioconductor/attachments /20040412/b8edc94b/RdbiPgSQL.bin
rdbipgsql • 353 views
ADD COMMENTlink modified 15.6 years ago by John Zhang2.9k • written 15.6 years ago by Mitchell Skinner40
Answer: [PATCH] apparent bug in RdbiPgSQL (logicals always false)
0
gravatar for John Zhang
15.6 years ago by
John Zhang2.9k
John Zhang2.9k wrote:
>The attached patch appears to solve the problem for me. >With the patch applied: Yes, a string comparison should be used. The bug has been fixed and will be removed from tomorrow's build of RdbiPgSQL. Thank you very much. > >> dbGetQuery(statgen, "SELECT true;") > bool >1 TRUE > >I'm assuming that the BioConductor list is the place to send this, since >I got RdbiPgSQL from BioConductor in the first place. If not, please >point me in the right direction. > >Regards, >Mitch Jianhua Zhang Department of Biostatistics Dana-Farber Cancer Institute 44 Binney Street Boston, MA 02115-6084
ADD COMMENTlink written 15.6 years ago by John Zhang2.9k
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 226 users visited in the last hour