Home > mailing lists

Pb with boolean between MS-Access and PostgreSQl 8.0.3 - Mailing list pgsql-general

From	Ets ROLLAND
Subject	Pb with boolean between MS-Access and PostgreSQl 8.0.3
Date	July 12, 2005 14:17:00
Msg-id	003a01c586ec$5c2bdef0$6400a8c0@lrp43208 Whole thread Raw
List	pgsql-general

Hello !

I use psql ODBC v.8.00.0101 with MS-Access 2002 under XP Pro.

If I use a System Data Source configured with :

Datasource using :

- Bool AS Char,

- True is -1.

So Query with criteria "true" work

but checked fields don't work !?

If Datasource use :

- Bool NOT char,

- True is -1.

So Query with criteria True don't work,

but checked fields work !?

How can I obtain an good support for logical

between MS-Access and PostgreSQL 8.0.3 ?

Thanks for any explaination...

Best regards

From: Michael Fuhr
Date: 12 July 2005, 14:15:30
Subject: Re: Db and schema names in logged errors

From: Tom Lane
Date: 12 July 2005, 14:19:38
Subject: Re: Converting MySQL tinyint to PostgreSQL