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

 

Syntax

 

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

 

<row value constructor> ::=

 

<explicit row value constructor> ::=

 

<row value element list> ::=

 

 

 

<row value element> [ { , <row value element> }... ]

 

<row value element> ::=

 

|

|

 

<value expression>

NULL

DEFAULT

 

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

 

<row value constructor predicand> ::=

 

 

Notes

 

Row value constructors with more than 1 row value element are only supported in the INSERT statement in NexusDB SQL.



 

 

Examples

 

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

 


SELECT studentName, state


FROM students


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



 

2)

The following example inserts two new rows into the documents table:



 


INSERT into documents ( documentID, title )


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



 

 


 

Conformance

 

SQL:2003 standard

-

Core SQL