Boolean Functions and Operators​

A boolean type with possible values of true and false.

EdgeQL has case-insensitive keywords and that includes the boolean literals:

db> 

SELECT (True, true, TRUE);

{(true, true, true)}

db> 

SELECT (False, false, FALSE);

{(false, false, false)}

A boolean value may arise as a result of a logical or comparison operations as well as IN and NOT IN:

db> 

SELECT true AND 2 < 3;

{true}

db> 

SELECT '!' IN {'hello', 'world'};

{false}

It is also possible to cast between bool, str, and json:

db> 

SELECT <json>true;

{'true'}

db> 

SELECT <bool>'True';

{true}

Filter clauses must always evaluate to a boolean:

SELECT User
FILTER .name ILIKE 'alice';

Logical disjunction.

db> 

SELECT false OR true;

{true}

Logical conjunction.

db> 

SELECT false AND true;

{false}

Logical negation.

db> 

SELECT NOT false;

{true}