Name
DB.DBA.VECTOR_OF_NONNULLS_AGG — Returns a vector of passed values ingoring NULL arguments.
Synopsis
vector DB.DBA.VECTOR_OF_NONNULLS_AGG ( |
value_expression any
); |
Description
DB.DBA.VECTOR_OF_NONNULLS_AGG
returns a vector of passed values. Similar to DB.DBA.VECTOR_AGG() but ignores NULL
arguments.
The order of items in the vector repeats the order of passing individual values to the aggregate.
Parameters
value_expression
Value of item for aggregation.
Return Types
Any
Examples
Example24.2.Simple Use
As the order of items in the vector repeats the order of passing individual values to the aggregate, it is possible to write, for instance:
-- Get an ordered vector of X-es SELECT DB.DBA.VECTOR_OF_NONNULLS_AGG (subquery.X) FROM (SELECT X FROM ... ORDER BY X) as subquery
or
SELECT DB.DBA.VECTOR_OF_NONNULLS_AGG (subquery.Y) FROM (SELECT Y FROM ... ORDER BY X) as subquery
and get vector of Y-s that are ordered by matching values of X-es.