Row Value Expressions

Wed, 03/04/2009 - 20:02 |  hdanzl

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

♦ Row value constructors with more than 1 row value element are only supported in the INSERT statement in NexusDB V3 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
‹ Boolean Value ExpressionsupSubqueries ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | Value Expressions

Powered by Drupal and Drupal Theme created with Artisteer.