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
Example 24.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