Re: Handlind booleans Postgresql-Access

Поиск
Список
Период
Сортировка
От Łukasz Jarych
Тема Re: Handlind booleans Postgresql-Access
Дата
Msg-id CAGv31odNT6K5jAKY5UXbeiAr4z9gZtZVfBfqcwad-oQ1Jkk6Xg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Handlind booleans Postgresql-Access  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Handlind booleans Postgresql-Access
Список pgsql-general
Hmm so maybe better is use text field here....

Best,
Jacek 

pt., 13 lip 2018 o 15:36 Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Disable TRUST authentication by using ClientAuthentication_hook
Следующее
От: Daniel Westermann
Дата:
Сообщение: PG11 Hash partitioning and null values in the partition key