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

From Tom Lane
Subject Re: How to implement Microsoft Access boolean (YESNO)
Date
Msg-id 8505.1138050132@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to implement Microsoft Access boolean (YESNO)  (Greg Stark <gsstark@mit.edu>)
Responses Re: How to implement Microsoft Access boolean (YESNO)  (Greg Stark <gsstark@mit.edu>)
List pgsql-sql
Greg Stark <gsstark@mit.edu> writes:
> "Jesper K. Pedersen" <jkp@solnet.homeip.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


pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: How to implement Microsoft Access boolean (YESNO)
Next
From: Greg Stark
Date:
Subject: Re: How to implement Microsoft Access boolean (YESNO)