This section describes the syntax of scalar expressions.
Contents
| Name | Description |
|---|---|
| Case expression | A function selecting a value conditionally. |
| expr-column-ref |
A reference to a column in an expression. A column might comprise another expression, or a reference to a database field. |
| expr-factor | A single value. |
| expr-primary-cast | Converts a value from one type to another. |
| expr-primary-constant | A constant keyword. |
| expr-primary-datetime | A date, time, or timestamp value. |
| expr-primary-element | Extracts one element from a string of delimiter separated elements. |
| expr-primary-format | Returns a string formatted according to instructions contained in a format String expression. |
| expr-primary-interval |
An interval value. Take care when specifying a MONTH interval, to ensure that the query evaluates correctly in all cases. |
| expr-primary-location | A geographical location. |
| expr-primary-odbc-datetime | A date, time, or timestamp value. |
| expr-primary-odbc-function | An ODBC function. |
| expr-primary-odbc-timestampadd |
Adds a number of specified intervals to a timestamp. Take care when specifying a MONTH interval, to ensure that the query evaluates correctly in all cases. |
| expr-primary-odbc-timestampdiff | Returns the difference between two timestamps. |
| expr-primary-opc-time | An OPC relative time. |
| expr-primary-region | A geographical region. |
| expr-primary-sumfunc | An aggregate function returning a summary of data returned in a query. |
| expr-term | One or more expression factors separated by multiply, divide or concatenate operators. |
| expression | One or more expression terms separated by addition and/or subtract operators. |
| Numeric value function | A function returning a numeric value. |
| String value function | A function returning a string value. |