Postgres-XC 1.0.3 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 8. Data Types | Fast Forward | Next |
Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly.
Postgres-XC 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.
Valid literal values for the "true" state are:
TRUE |
't' |
'true' |
'y' |
'yes' |
'on' |
'1' |
FALSE |
'f' |
'false' |
'n' |
'no' |
'off' |
'0' |
Example 8-2 shows that boolean values are output using the letters t and f.