Scott Walter wrote:
>
> One of the attributes in my db is of type boolean, which when linked to MS
> Access assumes type Yes/No. However, when I attempt to query through
> Access for all tuples that are 'true' I get the following messages returned
> by Access, and the log file was no help.
>
> "ODBC--call failed"
>
> "Error while executing the query (non-fatal);
> ERROR: Unable to identify an operator '=' for types 'bool' and 'int4'
> You will have to retype this query using an explicit cast (#-1)"
>
Check the driver option "Bools as char".
regards,
Hiroshi Inoue