Boolean Data Type

The BOOLEAN data type stores boolean values .

Boolean values are TRUE, FALSE, and UNKNOWN, where UNKNOWN is a synonym of NULL.

CREATE ROW TABLE TEST (A BOOLEAN);
INSERT INTO TEST VALUES (TRUE);
INSERT INTO TEST VALUES (FALSE);
INSERT INTO TEST VALUES (UNKNOWN);
INSERT INTO TEST VALUES (NULL);

SELECT A "boolean" FROM TEST WHERE A = TRUE;