Re: ODBC Boolean handling - Mailing list pgsql-patches

From Hiroshi Inoue
Subject Re: ODBC Boolean handling
Date
Msg-id 3B68AEFC.B1443DB1@tpf.co.jp
Whole thread Raw
In response to ODBC Boolean handling  (Aidan Mountford <Aidan@oz.to>)
Responses Re: ODBC Boolean handling  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Aidan Mountford wrote:
>
> I had a few issues with boolean handling in ODBC driver.
>
> 1) When a row is retrieved, and then a SQL_FETCH_FIRST is issued, the check
> in convert.c
> does not consider the fact that the value in the field has been altered to
> be a '1' if the
> backend handed it a 't'.  The net result being that the first row on any
> subsequent queries
> has all it's boolean set to 0.
>

You seem to be right.
I would commit it as soon as I am able to have a cvs access(
I hope it would be before 7.2 release).

> 2) I had issues with some utilities that, when casting from string to
> boolean, and having
> the global 'bools as char' set, require that -1 = True, and 0 = false.
>

Hmm I don't understand this.
Please explain more in detail.

regards,
Hiroshi Inoue

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch for Improved Syntax Error Reporting
Next
From: Bruce Momjian
Date:
Subject: Re: Revised Patch to allow multiple table locks in "Unison"