||bool||logical boolean (true/false)|
BOOLEAN type represents a statement of truth (“true” or “false”). In SQL, the boolean field can also have a third state “unknown” which is represented by the SQL NULL value.
-- select the three possible values of a boolean column SELECT TRUE, FALSE, NULL::BOOLEAN;
Boolean values can be explicitly created using the literals
FALSE. However, they are most often created as a result of comparisons or conjunctions. For example, the comparison
i > 10 results in a boolean value. Boolean values can be used in the
HAVING clauses of a SQL statement to filter out tuples from the result. In this case, tuples for which the predicate evaluates to
TRUE will pass the filter, and tuples for which the predicate evaluates to
NULL will be filtered out. Consider the following example:
-- create a table with the value (5), (15) and (NULL) CREATE TABLE integers(i INTEGER); INSERT INTO integers VALUES (5), (15), (NULL); -- select all entries where i > 10 SELECT * FROM integers WHERE i > 10; -- in this case (5) and (NULL) are filtered out: -- 5 > 10 = FALSE -- NULL > 10 = NULL -- The result is (15)
See Logical Operators and Comparison Operators.