I transferred a couple of tables from an Access MDB to Postgres.
Among the involved column-types are booleans.
I could dump the contend of the Access table to PG via an odbc linked table.
In psql I can run :
SELECT count(*) FROM my_table WHERE some_boolean;
It shows some number as expected.
I Access I get an Error:
Error: Operator doesn't exist: boolean = integer (#7)
In the System-DSN I have
Bool as Char : NO
True is -1 : YES
How can have booleans that don't break my Access front-end ?
pgsql-odbc by date
|Next:||From: Richard Huxton||Date: 2004-01-19 09:36:46|
|Subject: Re: error 3669 in psql 7.2|
|Previous:||From: Robert Roebling||Date: 2004-01-16 21:08:01|
|Subject: Newbie unable to connect through iODBC|