Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

sqlways/postgresql/data-types/boolean.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement