Logic

if

if(condition,yesValue,noValue)

Controls conditional branching.

For example if(1=2,'a','b') will get b

multi_if

multi_if(condition1, then1, condition2, then2.. ,else) An easier way to write if/self or case/when.

case_with_expression

case_with_expression(expression, condition1, value1, condition2, value2, ..., default_value)

Timeplus supports CASE WHEN .. THEN .. ELSE .. END operator. It is used to evaluate a series of conditions and return a value based on the first condition that evaluates to true.

Timeplus supports two forms:

• CASE WHEN .. THEN .. ELSE .. END
• CASE .. WHEN .. THEN .. ELSE .. END

For example:

-- common form in other SQL databases
SELECT number,
CASE
    WHEN number % 2 = 0 THEN number + 1
    WHEN number % 2 = 1 THEN number * 10
    ELSE number
END AS result
FROM ..

-- the other form is optimized for constant value
-- this will be translated to case_with_expression(number, 0, 100, 1, 200, 0)
SELECT number,
CASE number
    WHEN 0 THEN 100
    WHEN 1 THEN 200
    ELSE 0
END AS result
FROM ..

and

and(val1, val2...) Calculates the logical conjunction of two or more values.

or

or(val1, val2...) Calculates the logical disjunction of two or more values.

not

not(val) Calculates the logical negation of a value.

xor

xor(val1, val2...) Calculates the logical exclusive disjunction of two or more values. For more than two input values, the function first xor-s the first two values, then xor-s the result with the third value etc.

sleep

sleep(seconds)

Not necessary as a logic function, but it is a function that can be used to pause the execution for a specified number of seconds.

For example select sleep(2) will pause the execution for 2 seconds.