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. |
| expression | One or more expression terms separated by addition and/or subtract operators |
| 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 |
| expr-primary-location | A location function that allows you to specify location values. |
| 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 |
| expr-primary-odbc-timestampdiff | Returns the difference between two timestamps |
| expr-primary-opc-time | An OPC relative time |
| 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 |
| Numeric value function | A function returning a numeric value |
| String value function | A function returning a string value |