Postgres Pro
Downloads
Home   >   mailing lists

How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? - Mailing list pgsql-sql

From Jesper K. Pedersen
Subject How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ?
Date
Msg-id 20060122211351.371f20d8@io.solnet
Whole thread Raw
Responses Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
I am have some difficulties converting the Microsoft field of type
YESNO (which is a simple boolean true/false) to something that is
compatible with PostgreSQL.

I have tried with both boolean, bit(1) and even integer to try and get
it to work but with no success - Access see the boolean and bit(1) as
"text" fields.

This mean that I am not able to use the built-in form input fields for
the "YESNO" field type.

Anyone with any ideas on how to get around this?

Thank's Jesper K. Pedersen

pgsql-sql by date:

Previous
From: Zulq Alam
Date:
Subject: Re: indexing for left join
Next
From: Tom Lane
Date:
Subject: Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ?