github.com/mithrandie/csvq@v1.18.1/docs/_posts/2006-01-02-row-value.md (about)

     1  ---
     2  layout: default
     3  title: Row Value - Reference Manual - csvq
     4  category: reference
     5  ---
     6  
     7  # Row Value
     8  
     9  A Row Value is an ordered list of values.
    10  
    11  ```sql
    12  row_value
    13    : (value [, value...])
    14    | (select_query)
    15    | JSON_ROW(json_query, json_data)
    16  ```
    17  
    18  _value_
    19  : [value]({{ '/reference/value.html' | relative_url }})
    20  
    21  _select_query_
    22  : [Select Query]({{ '/reference/select-query.html' | relative_url }})
    23    
    24    Retrieved fields of _select_query_ are used as listed values.
    25    The result set of _select_query_ must have at most one record.
    26  
    27  _json_query_
    28  : [JSON Query]({{ '/reference/json.html#query' | relative_url }})
    29    
    30    Empty string is equivalent to "\[\]".
    31  
    32  _json_data_
    33  : [string]({{ '/reference/value.html#string' | relative_url }})
    34  
    35  Row Values can be used in limited operation such as [Comparison Operation]({{ '/reference/comparison-operators.html' | relative_url }}) or [Insert Query]({{ '/reference/insert-query.html' | relative_url }}).
    36  In most cases, a row value with a single value is interpreted as a value with parentheses.