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
>
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 |