DB.DBA.BAG_OF_NONNULLS

Name

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

vector DB.DBA.BAG_OF_NONNULLS_AGG ( value_expression any );

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.

Value of item for aggregation.

Any

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

Prev	Up	Next
DB.DBA.BAG_AGG	Home	DB.DBA.BAG_OR_NULL_AGG

Prefix	IRI
schema	http://schema.org/
n4	http://creativecommons.org/licenses/by/4.0/
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
n5	http://www.openlinksw.com/#
n2	http://docs.openlinksw.com/virtuoso/fn_bag_of_nonnulls_agg/
xsdh	http://www.w3.org/2001/XMLSchema#

Prefix	URI
xmlns:schema	http://schema.org/
xmlns:n4	http://creativecommons.org/licenses/by/4.0/
xmlns:rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
xmlns:n5	http://www.openlinksw.com/#
xmlns:n2	http://docs.openlinksw.com/virtuoso/fn_bag_of_nonnulls_agg/
xmlns:xsdh	http://www.w3.org/2001/XMLSchema#

Subject	Predicate	Object
n2:	rdf:type	schema:TechArticle
n2:	rdf:type	schema:APIReference
n2:	schema:name	DB.DBA.BAG_OF_NONNULLS_AGG
n2:	schema:copyrightHolder	_:vb79088
n2:	schema:datePublished	2016-09-09 16:16:54
n2:	schema:headline	DB.DBA.BAG_OF_NONNULLS_AGG
n2:	schema:keywords	OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data,function,API,reference,bag_of_nonnulls_agg
n2:	schema:license	n4:deed.en_US
n2:	schema:publisher	_:vb79087
n2:	schema:url	n2:
_:vb79087	rdf:type	schema:Organization
_:vb79087	schema:name	OpenLink Software
_:vb79087	schema:url	n5:this
_:vb79088	rdf:type	schema:Organization
_:vb79088	schema:name	OpenLink Software
_:vb79088	schema:url	n5:this