Download HyperSQL User Guide

Data Access and Change
<interval term> ::= <interval factor> | <interval term 2> <asterisk> <factor>
| <interval term 2> <solidus> <factor> | <term> <asterisk> <interval factor>
<interval factor> ::= [ <sign> ] <interval primary>
<interval primary> ::= <value expression primary> [ <interval qualifier> ] |
<interval value function>
<interval value expression 1> ::= <interval value expression>
<interval term 1> ::= <interval term>
<interval term 2> ::= <interval term>
Specify an interval value. Details are described in the SQL Language chapter.
interval absolute value function
interval value function
<interval value function> ::= <interval absolute value function>
<interval absolute value function> ::= ABS <left paren> <interval value expression> <right paren>
Specify a function that returns the absolute value of an interval. If the interval is negative, it is negated, otherwise
the original value is returned.
boolean value expression
boolean value expression
<boolean value expression> ::= <boolean term> | <boolean value expression> OR
<boolean term>
<boolean term> ::= <boolean factor> | <boolean term> AND <boolean factor>
<boolean factor> ::= [ NOT ] <boolean test>
<boolean test> ::= <boolean primary> [ IS [ NOT ] <truth value> ]
<truth value> ::= TRUE | FALSE | UNKNOWN
<boolean primary> ::= <predicate> | <boolean predicand>
<boolean predicand> ::= <parenthesized boolean value expression> | <nonparenthesized value expression primary>
<parenthesized boolean value expression> ::= <left paren> <boolean value expression> <right paren>
Specify a boolean value.
Predicates
Predicates are conditions with two sides and evaluate to a boolean value. The left side of the predicate, the <row
value predicand>, is the common element of all predicates. This element is a generalisation of both <value
expression>, which is a scalar, and of <explicit row value constructor>, which is a row. The two
106