Scalable Database Server, HiRDB Version 8 SQL Reference
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
(1) Function
Specifies either rows or a list of ordered columns.
(2) Format
row-value-constructor::= {row-value-constructor-element
| (row-value-constructor-element
[,row-value-constructor-element] ...) | row-subquery}
row-value-constructor-element::= value-expression
- The maximum number of row value constructor elements that can be specified in a row value constructor is 255.
- The following data types cannot be specified for columns of the results of a row value constructor:
- BLOB
- BINARY with a minimum definition length of 32,001 bytes
- Abstract data type
- BOOLEAN
- In the specification of two or more row value constructor elements, if a repetition column is specified as a row value constructor element, the subscript ANY cannot be specified.
- For details about row subqueries, see 2.4 Subqueries.
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.