--- Fred Parkinson <FredP(at)abag(dot)ca(dot)gov> wrote:
> Here is a problem that disappears when logging is
What version of PostgreSQL is this?
> 2. ERROR: Unable to identify an operator "=" for
> types "boolean" and "integer"
> You will have to retype this query using an
> explicit cast (#7)
Sounds like an old problem. Try running the following
code in in PostgreSQL:
CREATE FUNCTION MsAccessBool (bool, int4) RETURNS BOOL
IF $1 ISNULL THEN
IF $1 IS TRUE THEN
IF $2 <> 0 THEN
IF $2 = 0 THEN
' LANGUAGE 'plpgsql';
CREATE OPERATOR = (
LEFTARG = BOOL,
RIGHTARG = INT4,
PROCEDURE = MsAccessBool,
COMMUTATOR = '=',
NEGATOR = '<>',
RESTRICT = EQSEL,
JOIN = EQJOINSEL
If this doesn't help you, please post your ODBC driver
settings. I assume these are boolean fields in
PostgreSQL: they should show as "yes/no" in Access.
If they do not, try relinking your tables after
running the above code.
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2003-02-24 02:48:05|
|Subject: Re: Unicode, ODBC and MS Access|
|Previous:||From: Renê Salomão||Date: 2003-02-20 19:30:46|
|Subject: Help Installing ODBC!!|