Boolean Type

Compared to the original MogDB, dolphin's modifications to boolean types are mainly:

• Modify the output representation of boolean types from 't' and 'f' to '1' and '0'. This change only works with tools other than gs_dump, gs_dumpall, gsql, gs_probackup, gs_rewind, gs_clean, such as JDBC.

For more information on the original MogDB boolean types, see Boolean Data Types.

Example

-- Boolean type returns are still 't' and 'f' in gsql.
MogDB=# SELECT true;
 bool
------
 t
(1 row)

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