Hi,
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:
ODBC-Call failed.
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 ?
cu
Andreas