SQL Language Extension: LIST

Function:
    This function returns a string result with the concatenated non-NULL
    values from a group. It returns NULL if there are no non-NULL values.

Authors:
    Oleg Loa <[email protected]>
    Dmitry Yemanov <[email protected]>

Format:

  <list function> ::=
      LIST '(' [ {ALL | DISTINCT} ] <value expression> [',' <delimiter value> ] ')'

  <delimiter value> ::=
      { <string literal> | <parameter> | <variable> }

Syntax Rules:
    1) If neither ALL nor DISTINCT is specified, ALL is implied.
    2) If <delimiter value> is omitted, a comma is used to separate
       the concatenated values.

Notes:
    1) Numeric and datetime values are implicitly converted to strings
       during evaluation.
    2) The result value is of type BLOB with SUB_TYPE TEXT for all cases
       except list of BLOB with different subtype.
    3) Ordering of values within a group is implementation-defined.

Examples:

A)
  SELECT LIST(ID, ':')
  FROM MY_TABLE

B)
  SELECT TAG_TYPE, LIST(TAG_VALUE)
  FROM TAGS
  GROUP BY TAG_TYPE