Re: Handlind booleans Postgresql-Access

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Łukasz Jarych <jaryszek(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Handlind booleans Postgresql-Access
Date: 2018-07-13 13:36:25
Message-ID: 14ee2354-929f-5a39-edef-a1c968dcd405@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-07-13 13:51:19 Re: Disable TRUST authentication by using ClientAuthentication_hook
Previous Message Guillaume Lelarge 2018-07-13 13:36:16 Re: Disable TRUST authentication by using ClientAuthentication_hook