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

"Jesper K. Pedersen" <jkp(at)solnet(dot)homeip(dot)net> writes:
> 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.

Assume that we have no idea what that is ;-). What is the I/O format
MSSQL uses for this datatype? Is YESNO actually the name of the type?

If the problem is that Access is looking for that specific type name,
you could probably fake it out by creating a domain:

create domain yesno as boolean;
create table foo (mycol yesno);

This will only work if the I/O format is 't' and 'f', though.
Otherwise you'll need to make the domain be over a type with
suitable I/O format (perhaps integer or text will work).

regards, tom lane