Help Center/ Data Lake Insight/ HetuEngine SQL Syntax Reference/ HetuEngine SQL Syntax/ Data Type/ Boolean
Updated on 2025-08-06 GMT+08:00
View PDF

Boolean

The valid text values for "true" are TRUE, t, true, and 1.

The valid text values for the "false" value are FALSE, f, false, and 0.

TRUE and FALSE are standard usages (SQL-compatible).

Example:

select BOOLEAN '0';
 _col0 
-------
 false 
(1 row)
 
select BOOLEAN 'TRUE';
 _col0 
-------
 true  
(1 row)
 
select BOOLEAN 't';
 _col0 
-------
 true  
(1 row)
Parent topic: Data Type