Name
DB.DBA.BAG_OF_NONNULLS_OR_NULL_AGG — Returns a vector of passed values ingoring NULL arguments.
Synopsis
vector DB.DBA.BAG_OF_NONNULLS_OR_NULL_AGG ( |
value_expression any
) ; |
Description
DB.DBA.BAG_OF_NONNULLS_OR_NULL_AGG
returns a vector of passed values. Similar to DB.DBA.BAG_OF_NONNULLS_AGG() but
returns NULL instead of an empty vector if no arguments were passed
or only NULLs were passed.
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. If no arguments were passed teturns NULL instead of an empty vector or only NULLs were passed.
Examples
Example24.9.Simple Use
SELECT DB.DBA.BAG_OF_NONNULLS_OR_NULL_AGG (subquery.X) FROM (SELECT X FROM ... ORDER BY X) as subquery