This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
PostgreSQL provides the
standard SQL type boolean; see Table 8-19. The
boolean type can have several states:
"true", "false", and a third state, "unknown", which is represented by the
SQL null value.
Table 8-19. Boolean Data Type
| Name |
Storage Size |
Description |
| boolean |
1 byte |
state of true or false |
Valid literal values for the "true"
state are:
| TRUE |
| 't' |
| 'true' |
| 'y' |
| 'yes' |
| 'on' |
| '1' |
For the
"false" state, the following
values can be used:
| FALSE |
| 'f' |
| 'false' |
| 'n' |
| 'no' |
| 'off' |
| '0' |
Leading or trailing whitespace is ignored, and case does not
matter. The key words
TRUE and
FALSE are the preferred (
SQL-compliant) usage.
Example
8-2 shows that boolean values are output
using the letters t and f.
Example 8-2. Using the boolean
Type
CREATE TABLE test1 (a boolean, b text);
INSERT INTO test1 VALUES (TRUE, 'sic est');
INSERT INTO test1 VALUES (FALSE, 'non est');
SELECT * FROM test1;
a | b
---+---------
t | sic est
f | non est
SELECT * FROM test1 WHERE a;
a | b
---+---------
t | sic est