pgsql-bugs@postgresql.org wrote:
>
> Miguel Juan (mjuan@cibal.es) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> Erroneus values of BOOLEANS
>
> Long Description
> I did not find a "report a bug" for the ODBC driver so I send it here:
>
> I thing it is a problem of the ODBC driver, when you unmark the option "Bools as char" in the ODBC conficuration,
always returns "false" in any querys that have to returns a boolean type.
>
> The problem is when you ask the value of the field it returns FALSE.
>
> I'm using PostgreSQL 7.2 and ODBC driver is the 7.01.00.07
>
> You can go arround checking the "bools as char option" and then you can compare the result as a integer or a string
(0:false, 1:true)
>
It may be my fault, sorry.
Please try psqlodbc-07_01_0008 at
http://odbc.postgresql.org/ftpsite/odbc/versions/dll/ .
regards,
Hiroshi Inoue