Name

DB.DBA.BAG_OF_NONNULLS_AGG — Returns a vector of passed values ingoring NULL arguments.

Synopsis

vector DB.DBA.BAG_OF_NONNULLS_AGG ( value_expression any );
 

Description

DB.DBA.BAG_OF_NONNULLS_AGG returns a vector of passed values. Similar to DB.DBA.VECTOR_OF_NONNULLS_AGG() but ignores NULL arguments.

The order of items in the vector is not predefined and may vary from run to run.

Parameters

value_expression

Value of item for aggregation.

Return Types

Any

Examples

Example 24.7. Simple Use

SELECT DB.DBA.BAG_OF_NONNULLS_AGG (subquery.X)
FROM (SELECT X FROM ... ORDER BY X) as subquery
SELECT DB.DBA.BAG_OF_NONNULLS_AGG (subquery.Y)
FROM (SELECT Y FROM ... ORDER BY X) as subquery