1.1

-- insert a row with a DEFAULT value for the STATUS column
INSERT INTO TRADE.SELLORDERS (OID , CID, SID, STATUS, TID)
VALUES (1,1,2,DEFAULT,2)
-- using a built-in function
VALUES CURRENT_DATE
-- getting the value of an arbitrary expression
VALUES (3*29, 26.0E0/3)
-- getting a value returned by a built-in function
values char(1)
Expression Precedence
You can explicitly specify precedence by placing expressions within parentheses. An expression within parentheses
is evaluated before any operations outside the parentheses are applied to it.
The precedence of operations from highest to lowest is:
• (), ?, Constant (including sign), NULL,ColumnReference, ScalarSubquery, CAST
• LENGTH, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, and other built-ins
• unary + and -
• *, /, || (concatenation)
• binary + and -
• comparisons, quantified comparisons, EXISTS, IN, IS NULL, LIKE, BETWEEN, IS
• NOT
• AND
• OR
Example
(3+4)*9
(age < 16 OR age > 65) AND employed = TRUE
Boolean Expressions
Boolean expressions are allowed in WHERE clauses and in check constraints.
Boolean expressions are allowed in WHERE clauses and in check constraints. Boolean expressions in check
constraints have limitations not noted here; see CONSTRAINT clause for more information. Boolean expressions
in a WHERE clause have a highly liberal syntax; see WHERE clause, for example.
A boolean expression can include a boolean operator or operators. These operators are listed in the following
table.
Table 6: SQL Boolean operators
SyntaxExplanation and ExampleOperator
{
Evaluate any operand(s) that are boolean expressions
(orig_airport = 'SFO') OR
AND, OR, NOT
Expression
(dest_airport = 'GRU')
AND
vFabric SQLFire User's Guide530
vFabric SQLFire Reference