Re: How to implement Microsoft Access boolean (YESNO)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: "Jesper K(dot) Pedersen" <jkp(at)solnet(dot)homeip(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to implement Microsoft Access boolean (YESNO)
Date: 2006-01-23 21:02:12
Message-ID: 8505.1138050132@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greg Stark <gsstark(at)mit(dot)edu> writes:
> "Jesper K. Pedersen" <jkp(at)solnet(dot)homeip(dot)net> writes:
>> Having checked the I/O format it seems that MS Access exports the
>> values of a YESNO field as 0 and 1

> If only Postgres's boolean type were as helpful.

There's a cast to int in 8.1, and you can roll-your-own easily in prior
releases ...

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2006-01-24 05:03:48 Re: How to implement Microsoft Access boolean (YESNO)
Previous Message Greg Stark 2006-01-23 20:53:11 Re: How to implement Microsoft Access boolean (YESNO)