I have a target table that is in PostgreSQL. I have a field in that table that is of type bit. I have a mapper before an INSERT PostgreSQL Snap type. I’m trying to use an expression to map to the bit field type but everything I try has a type mismatch. I’ve tried 1, ‘1’, true, ‘true’, and a few other things and it always complains that I’m inserting a varchar or int type instead of a bit. How could I get this to work?
