Thread: Bug #487: Erroneus values of BOOLEANS

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) 



Sample Code


No file was uploaded with this report

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