Re: [SQL] How to implement Microsoft Access boolean (YESNO)

2006-01-22 Thread Jesper K. Pedersen
On Sun, 22 Jan 2006 15:46:11 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "Jesper K. Pedersen" <[EMAIL PROTECTED]> 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. >

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

2006-01-22 Thread Tom Lane
"Jesper K. Pedersen" <[EMAIL PROTECTED]> 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 f

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

2006-01-22 Thread Jesper K. Pedersen
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