Richard Broersma Jr wrote:
> I am using the ODBC provider [8.02.05.0000] to connect my postgresql database [8.2.5] with my MS ACCESS XP front-end.
> This is what I am seeing: When I issue a select statement from with-in ms-access, the Boolean field that contain null values are returning as false( as 0 in the datasheet view). My expectation is that null Boolean values display as null rather than false. When I issue the same query with-in psql the null boolean values correctly display as NULL.
> A while back I applied the following directions to MS-Access' [yes/no] type to create a better mapping with PostgreSQL's Boolean type. I don't know if these direction are redundant to what is already provided in the ODBC provider. Perhaps the operator that I've created is causing the problem I am seeing.
Using inttobool(int, bool) defined in the above URL, I see the
xxxxx=> select inttobool(NULL, true);
xxxxx=> select inttobool(NULL, false);
Is it what you expected ?
In response to
pgsql-odbc by date
|Next:||From: Richard Broersma Jr||Date: 2007-11-06 01:43:00|
|Subject: Re: Either I broke PostgreSQL or I found an ODBC bug|
|Previous:||From: Richard Broersma Jr||Date: 2007-11-05 23:35:55|
|Subject: Either I broke PostgreSQL or I found an ODBC bug |