Skip to main content Link Menu Expand (external link) Document Search Copy Copied

BOOL data type

DDL Syntax



Argument Description
BOOL The BOOL type stores simple Boolean (true/false) values and is used for simple query filtering.

Additional information

Use this table to determine how integer and string values are represented when added to a Boolean column.

data value bool
integer 0 0
integer > 0 1 1
string empty, 0, f, false 0
string other string values 1


CREATE TABLE with all data types

create table allcoltypes
    _id id,
    intcol int min 0 max 10000,
    boolcol bool,
    timestampcol timestamp timeunit 'ms',
    decimalcol decimal(2),
    stringcol string,
    stringsetcol stringset,
    stringsetcolq stringsetq timequantum 'YMD' ttl '24h',
    idcol id,
    idsetcol idset,
    idsetcolq idsetq timequantum 'YMD' ttl '24h'
  comment 'table containing all column types';