| SQL adaptation guide For PostgreSQL 8.x.y, 9.x.y / Data dictionary | |
Informix® supports the BOOLEAN data type, which can store 't' or 'f' values. Genero BDL implements the BOOLEAN data type in a different way; as in other programming languages, Genero BOOLEAN stores integer values 1 or 0 (for TRUE or FALSE). The type was designed this way to assign the result of a boolean expression to a BOOLEAN variable.
PostgreSQL supports the BOOLEAN data type and stores 't' or 'f' values for TRUE and FALSE representation. It is not possible to insert the integer values 1 or 0; values must be true, false, '1' or '0'.
The PostgreSQL database interface supports the BOOLEAN data type, and converts the BDL BOOLEAN integer values to a CHAR(1) of 't' or 'f'.