Re: Handlind booleans Postgresql-Access - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Handlind booleans Postgresql-Access
Date
Msg-id 14ee2354-929f-5a39-edef-a1c968dcd405@aklaver.com
Whole thread Raw
In response to Handlind booleans Postgresql-Access  (Łukasz Jarych <jaryszek@gmail.com>)
Responses Re: Handlind booleans Postgresql-Access
List pgsql-general
On 07/13/2018 02:19 AM, Łukasz Jarych wrote:
> Hi Guys,
> 
> i created boolean in postgresql table (in attachment) but linked table 
> in Access see this as short text.
> 
> I checked in odbc option Bools as Char to false and True is -1 as 
> true.but still tihs is not working.

Define working.

> 
> I found linke here:
> 
> http://bahut.alma.ch/2006/04/access-odbc-postgresql-boolean-mess.html
> 
> but this is very strange function there (which i am not understanding), 
> why to use it? There is no other option?

Because Postgres has true boolean fields and Access does not.

> 
> Best,
> Jacek
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Disable TRUST authentication by using ClientAuthentication_hook
Next
From: Tom Lane
Date:
Subject: Re: Disable TRUST authentication by using ClientAuthentication_hook