How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ?

From: "Jesper K(dot) Pedersen" <jkp(at)solnet(dot)homeip(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ?
Date: 2006-01-22 20:13:51
Message-ID: 20060122211351.371f20d8@io.solnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-01-22 20:46:11 Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ?
Previous Message Zulq Alam 2006-01-21 13:51:56 Re: indexing for left join