SELECT fieldlist, CASE WHEN myboolean = true THEN 1 ELSE 0 END FROM tblname WHERE condition;
""Jesper K. Pedersen"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
