Re: Handlind booleans Postgresql-Access

From: Łukasz Jarych <jaryszek(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "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:56:18
Message-ID: CAGv31odNT6K5jAKY5UXbeiAr4z9gZtZVfBfqcwad-oQ1Jkk6Xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hmm so maybe better is use text field here....

Best,
Jacek

pt., 13 lip 2018 o 15:36 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
napisał(a):

> 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 Daniel Westermann 2018-07-13 14:05:26 PG11 Hash partitioning and null values in the partition key
Previous Message Tom Lane 2018-07-13 13:51:19 Re: Disable TRUST authentication by using ClientAuthentication_hook