Re: Handlind booleans Postgresql-Access - Mailing 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