Name

DB.DBA.GROUP_DIGEST — returns an arbitrary value from the multiset passed to it.

Synopsis

DB.DBA.GROUP_DIGEST ( in token varchar ,
  in delim varchar ,
  in maxlen integer ,
  in mode integer );
 

Description

DB.DBA.GROUP_DIGEST is aggregate function that performs a string concatenation across the values of an expression with a group. The order of the strings is not specified. The separator character used in the concatenation may be given with the scalar argument delimiter. The function is an extended version of sql:GROUP_CONCAT(), with two more arguments: maxlen and mode.

Note: the "sql:" prefix is mandatory when this aggregate is used in SPARQL queries. In SQL queries the prefix is "DB.DBA".

Parameters

token

An item that should be added to a delimited list.

delim

The delimeter character to be used in the concatenation.

maxlen

The maximal allowed length of the result, in characters. Redundant values will be ignored. If the last value does not fit in the "maxlen" entirely, then it can be truncated and "..." is placed at the end of the resulting string.

mode

Bitmask of properties. Right now only bit 1 is used and others are reserved. If the value of the argument is 1 then duplicate values are ignored; value 0 will put duplicate values like in case of sql:GROUP_CONCAT ().

Return Types

any

Examples

Example 24.289. Get all ?assets as a list with delimiters.

SQL>SPARQL
SELECT ?view (sql:GROUP_DIGEST (?path, ' ', 1000, 1)) as ?path_list
    (sql:GROUP_DIGEST (?asset, ' ', 1000, 1)) as ?asset_list
FROM <http://mygraph.com>
WHERE
  {
    ?view <viewPath> ?path ;
      <viewContent> ?asset ;
      <viewType>  'phyview'.
  };