Boolean Types

Compared with the original openGauss, Dolphin modifies the Boolean type as follows:

• The output representations of the Boolean type are changed from 't' and 'f' to '1' and '0'. This modification takes effect only on tools except gs_dump, gs_dumpall, gsql, gs_probackup, gs_rewind, and gs_clean, for example, JDBC.

For more information about the Boolean type of the original openGauss, see openGauss Boolean Types.

Examples

--In gsql, the output of the Boolean type is still 't' and 'f'.
openGauss=# SELECT true;
 bool
------
 t
(1 row)

openGauss=# SELECT false;
 bool
------
 f
(1 row)