Name

DB.DBA.VECTOR_CONCAT_AGG — Expects SQL vectors as arguments and the result is a concatenation of all passed vectors.

Synopsis

vector DB.DBA.VECTOR_CONCAT_AGG ( _items any );

Description

DB.DBA.VECTOR_CONCAT_AGG expects SQL vectors as arguments and the result is a concatenation of all passed vectors.

Parameters

_items

SQL vectors.

Return Types

Any

Examples

Example24.5.Simple Use

The most typical usage is the composing of get-keyword style vector, for ex:

  SELECT DB.DBA.VECTOR_CONCAT_AGG (vector (U_NAME, U_ID))
    FROM DB.DBA.SYS_USERS
ORDER BY U_NAME;

which returns a vector of passed values. The order of items in the vector repeats the order of passing argument vectors to the aggregate.

 (dba, 0, dav, 2, administrators, 3, nobody, 5, nogroup, 6, __rdf_repl, 7, SPARQL_SELECT, 100, SPARQL_SPONGE, 101, ... )
No. of rows in result: 1