From: Bath, David <bathdt@challengelogistics.com.au>
To: pgsql-sql@postgresql.org
Subject: Re: How to implement Microsoft Access boolean (YESNO)
Date: Wed, 25 Jan 2006 12:05:09 +1100
Message-ID: <200601251205.09819.bathdt@challengelogistics.com.au> (raw)
In-Reply-To: <873bjewts8.fsf@stark.xeocode.com>
References: <20060122211351.371f20d8@io.solnet>
<20060122221328.433038a9@io.solnet>
<873bjewts8.fsf@stark.xeocode.com>
On Tue, 24 Jan 2006 07:53, Greg Stark wrote:
> > Having checked the I/O format it seems that MS Access exports the
> > values of a YESNO field as 0 and 1
Hmmm. I may be wrong, but last time I looked (a year or so ago), when
I cast MS-Access yes/no fields to numerics, it gave me 0=no or
all_bits_on=yes (which because MS lacks "unsigned", is -1).
--
David T. Bath
System Analyst, Challenge Logistics
75-85 Nantilla Road, Clayton North Vic 3168
Voice: 131323 Fax: +613 8562 0002
bathdt@challengelogistics.com.au
============================================================
IMPORTANT - This email and any attachments is confidential.
If received in error, please contact the sender and delete
all copies of this email. Please note that any use,
dissemination, further distribution or reproduction of this
message in any form is strictly prohibited. Before opening or
using attachments, check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused
by the negligence of the sender or not, resulting directly or
indirectly from the use of any attached files, our liability
is limited to resupplying any affected attachments.
Any representations or opinions expressed in this email are
those of the individual sender, and not necessarily those
of the Capital Transport Services.
============================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bathdt@challengelogistics.com.au
Subject: Re: How to implement Microsoft Access boolean (YESNO)
In-Reply-To: <200601251205.09819.bathdt@challengelogistics.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox