Pb with boolean between MS-Access and PostgreSQl 8.0.3

From: "Ets ROLLAND" <ets(at)rolland-fr(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Pb with boolean between MS-Access and PostgreSQl 8.0.3
Date: 2005-07-12 14:16:55
Message-ID: 003a01c586ec$5c2bdef0$6400a8c0@lrp43208
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-07-12 14:19:31 Re: Converting MySQL tinyint to PostgreSQL
Previous Message Michael Fuhr 2005-07-12 14:15:20 Re: Db and schema names in logged errors