Name
DB.DBA.BAG_AGG — Returns a vector of passed values.
Synopsis
vector DB.DBA.BAG_AGG ( |
value_expression any
) ; |
Description
DB.DBA.BAG_AGG()
returns a vector
of passed values.
This is similar to DB.DBA.VECTOR_AGG() and returns a vector of passed values but the order of items in the vector is not predefined and may vary from run to run.
A query with DB.DBA.BAG_AGG()
may
work faster than a similar query with DB.DBA.VECTOR_AGG() because DB.DBA.BAG_AGG()
gives more freedom to the SQL
optimizer. If the order is not important for your application,
consider using of DB.DBA.BAG_AGG()
.
Parameters
value_expression
Value of item for aggregation.
Return Types
Any
Examples
Example24.6.Simple Use
SELECT DB.DBA.BAG_AGG (subquery.X) FROM (SELECT X FROM ... ORDER BY X) as subquery