Ispirer Website
Ispirer Capabilities - PostgreSQL Migration
Free Trial
PostgreSQL Data Types - BOOLEAN
Versions: PostgreSQL 8.x and 7.x
PostgreSQL - BOOLEAN | |
---|---|
Syntax | BOOLEAN |
Data | Boolean data |
Range | TRUE, FALSE (they are PostgreSQL keywords) and NULL. Possible literal values for true state: TRUE, 'true', 't', 'yes', 'y' and '1'. Possible literal values for false state: FALSE, 'false', 'f', 'no', 'n' and '0' |
Error Handling | Leading and trailing spaces are ignored |
Storage Size | 1 byte |
Standards | ANSI SQL |
PostgreSQL BOOLEAN - Equivalents in Other Databases
Database | Data Type and Conversion |
---|---|
SQL Server | BIT, 0 or 'false', 1 or 'true' and NULL |
MySQL | BOOL, BOOLEAN, -128 to 127 and NULL |
Sybase ASE | BIT, 0 and 1, NULL is not allowed |
Informix | BOOLEAN, 't', 'f' and NULL |
All Data Types