1.0

ExplanationExpression type
In a concatenation expression, the concatenation operator, "||",
concatenates its right operand to the end of its left operand. Operates
on character and bit strings. See Concatenation operator.
Concatenation expression
The built-in string functions act on a String and return a string. See
LTRIM function, LCASE or LOWER function, RTRIM function,
TRIM function, SUBSTR function, and UCASE or UPPER function.
Built-in string functions
User functions return information about the current user as a String.
See CURRENT_USER function, and SESSION_USER function.
USER functions
Date and time expressions
A date or time expression results in a DATE, TIME, or TIMESTAMP value. Most of the general expressions
can result in a date or time value.
ExplanationExpression type
Returns the current date. See CURRENT_DATE function.
CURRENT_DATE
Returns the current time. See CURRENT_TIME function.
CURRENT_TIME
Returns the current timestamp. See CURRENT_TIMESTAMP
function.
CURRENT_TIMESTAMP
SelectExpression
A SelectExpression is the basic SELECT-FROM-WHERE construct used to build a table value based on filtering
and projecting values from other tables.
Syntax
SELECT [ DISTINCT | ALL ] SelectItem [ , SelectItem ]*
FROM Clause
[ WHERE Clause]
GROUP BY Clause on page 490
HAVING Clause on page 490
SelectItem:
{
* |
{ table-Name | correlation-Name } .* |
Expression [AS Simple-column-Name]
}
Description
The SELECT clause contains a list of expressions and an optional quantifier that is applied to the results of the
FROM CLAUSE and the WHERE clause. If DISTINCT is specified, only one copy of any row value is included
in the result. Nulls are considered duplicates of one another for the purposes of DISTINCT. If no quantifier, or
ALL, is specified, no rows are removed from the result in applying the SELECT clause (ALL is the default).
A SelectItem projects one or more result column values for a table result being constructed in a SelectExpression.
vFabric SQLFire User's Guide496
vFabric SQLFire Reference