Re: How to implement Microsoft Access boolean (YESNO) - Mailing list pgsql-sql

From Bath, David
Subject Re: How to implement Microsoft Access boolean (YESNO)
Date
Msg-id 200601251205.09819.bathdt@challengelogistics.com.au
Whole thread Raw
In response to Re: How to implement Microsoft Access boolean (YESNO)  (Greg Stark <gsstark@mit.edu>)
List pgsql-sql
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.
============================================================


pgsql-sql by date:

Previous
From: ody quraviharto
Date:
Subject: variable scooping
Next
From: Tino Wildenhain
Date:
Subject: Re: [GENERAL] hi all......................!!