1.1

ExplanationExpression type
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 519
HAVING Clause on page 520
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.
The result of the FROM CLAUSE is the cross product of the FROM items. The WHERE clause can further
qualify this result.
vFabric SQLFire User's Guide526
vFabric SQLFire Reference