NexusDB V3 Manual

Row Value Expressions

Specify a value or list of values to construct a row value.

Syntax

<row value expression> ::= <explicit row value constructor>

<explicit row value constructor> ::=

<row value constructor element list> ::=

<row value constructor element> ::= <value expression>

<contextually typed row value expression> ::= <contextually typed row value constructor>

<contextually typed row value constructor> ::=

<contextually typed value specification> ::=

<null specification> ::= NULL

<default specification> ::= DEFAULT

<contextually typed row value constructor element list> ::=

<contextually typed row value constructor element> ::=

<row value predicand> ::= <row value constructor predicand>

<row value constructor predicand> ::=

<contextually typed table value constructor> ::=

<contextually typed row value expression list> ::=

Notes

Examples

1) The following example selects students from California and New York:

      SELECT studentName, state

      FROM students

      WHERE state IN ( 'CA', 'NY' )

      INSERT into documents ( documentID, title )

      VALUES ( NEWGUID, 'NexusDB main features' ), ( NEWGUID, 'NexusDB special features' )

Conformance