Re: Access boolean vs pg bool

From: "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
To: 'Glenn' <glenn(at)pip(dot)com(dot)au>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Access boolean vs pg bool
Date: 2002-12-19 13:44:24
Message-ID: E382B5D8EDE1D6118DBE0008C759BCD6116B42@WCPEXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Glenn wrote:
> Anyone out there using access... Is there away to configure the odbc
> driver to allow you to assign an access True/False (-1/0) boolean type
> to a postgres boolean type (which i think is char(1))?
> I already have numerous functions which return True/False and don't
> want to have to use #IF POSTGRES #ELSE type stuff to use vba to cast
> my results to 1/0 for postgres Tia
> glenn
>
> --
> Glenn <glenn(at)pip(dot)com(dot)au>
>
I must admit, I just made the booleans int2s, not sure if there is a better
solution.
- Stuart

Browse pgsql-novice by date

  From Date Subject
Next Message ghaverla 2002-12-19 15:00:46 Re: The pg_hba.conf file
Previous Message Henshall, Stuart - Design & Print 2002-12-19 10:06:33 Re: pgsql vs odbc and speed: clarification required