Re: [ODBC] Either I broke PostgreSQL or I found an ODBC bug

• On Mon, 11/5/07, Hiroshi Inoue <inoue@tpf.co.jp> wrote:

> Using inttobool(int, bool) defined in the above URL, I see
> the
> following.
>
> xxxxx=> select inttobool(NULL, true);
> inttobool
> -----------
> f
> (1 row)
>
> xxxxx=> select inttobool(NULL, false);
> inttobool
> -----------
> f
> (1 row)
>
> Is it what you expected ?

No, I guess I did break Postgres with the inttobool function. :-(

I was expecting a null boolean to return a null and not return a false. I guess my next question would be, how do I go about extracting or fix the inttobool() function in postgres?

Ms-access can't update any of these records that have fields that incorrectly appear to be false when the contents are actually boolean null's, since Access includes these fields in the as part of the update statement's where condition that is sent to postgresql. When this happens PostgreSQL notifies MS-access that zero records where updated and the transaction is rolled back. i.e. update ... where chkfield = '0' -- when chkfield is acutally null.

Thanks for the help!
Regards, Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly