NexusDB V3 Manual

Value Expressions

Specify a scalar value.

Syntax

<value expression> ::=

<common value expression> ::=

<value expression primary> ::=

<nonparenthesized value expression primary> ::=

<value specification> ::=

<unsigned value specification> ::=

<general value specification> ::=

<target specification> ::=

Usage

Value expressions return values with a data type declared by the expression, and can be used in SQL everywhere a value is expected and the particular data type is permitted. Value expressions can be as simple as a literal or a column reference, or complex expressions involving arithmetic operations, combined boolean logic, scalar subqueries, case expressions and SQL functions.

Conformance

Numeric Value Expressions

String Value Expressions

DateTime Value Expressions

Boolean Value Expressions

Row Value Expressions

Subqueries

Case Expressions

Cast Specification