Skip site navigation (1) Skip section navigation (2)

Re: ERROR: invalid input syntax for type boolean: "-"(#7)

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Peter van Heck" <usenet(at)heckwork(dot)nl>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ERROR: invalid input syntax for type boolean: "-"(#7)
Date: 2004-10-01 19:55:54
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4306878@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
 

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Peter van Heck
> Sent: 29 September 2004 02:53
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] ERROR: invalid input syntax for type boolean: "-"(#7)
> 
> I get this error with an ms-access front-end boolean type 
> field where access produces "-1" and Postgresql's bool field 
> does not accept this.
> 
> Im using Postgres 7.4.5, Access 2002, mdac 2.8, psqlodbc-07_03_0200.
> 
> Is there a proper work around?

There is a 'True is -1' option on the second options dialog.

Regards, Dave

Responses

pgsql-odbc by date

Next:From: Dave PageDate: 2004-10-01 19:58:52
Subject: Re: problems with the ODBC driver
Previous:From: Amir ZichermanDate: 2004-10-01 18:36:08
Subject: Re: \n converted to \r\n

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group