[/map
{"- map/map "})
[/map/title
{"- topic/title "}) Sets (title][/map/topicref
{"- map/topicref "}) [/map/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Sets and Multi-assign Data (navtitle][/map/topicref/topicmeta/linktext
{"- map/linktext "}) Sets and Multi-assign Data (linktext][/map/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) EQL supports sets, in particular the use of sets to represent multi-assign attributes. (shortdesc] (topicmeta][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) About sets (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) About sets (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) EQL represents multi-assign attributes from collections as sets. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Aggregate functions (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) Aggregate functions (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) EQL provides three aggregators for working with sets. (shortdesc] (topicmeta][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) SET function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) SET function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The SET aggregation function takes a single-assign attribute and constructs a set of all of the (non-NULL) values from that attribute. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) SET_INTERSECTIONS function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) SET_INTERSECTIONS function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The SET_INTERSECTIONS aggregation function takes a multi-assign attribute and constructs a set that is the intersection of all of the values from that attribute. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) SET_UNIONS function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) SET_UNIONS function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The SET_UNIONS aggregation function takes a multi-assign attribute and constructs a set that is the union of all of the values from that attribute. (shortdesc] (topicmeta] (topicref] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Row functions (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) Row functions (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) EQL provides a number of row functions for working with sets. (shortdesc] (topicmeta][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) ADD_ELEMENT function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) ADD_ELEMENT function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The ADD_ELEMENT row function adds an element to a set. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) CARDINALITY function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) CARDINALITY function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The CARDINALITY row function takes a set and returns the number of elements in that set. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) DIFFERENCE function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) DIFFERENCE function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The DIFFERENCE row function takes two sets of the same data type and returns a set containing all of the elements of the first set that do not appear in the second set. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) FOREACH function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) FOREACH function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The FOREACH function performs a computation on every member of a set or sets and assembles the results into a set. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) INTERSECTION function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) INTERSECTION function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The INTERSECTION row function takes two sets of the same data type and returns a set that is the intersection of both input sets. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) IS_EMPTY and IS_NOT_EMPTY functions (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) IS_EMPTY and IS_NOT_EMPTY functions (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The IS_EMPTY and IS_NOT_EMPTY functions determine whether a set is or is not empty. The IS EMPTY and IS NOT EMPTY functions provide alternative syntaxes for these functions. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) IS_MEMBER_OF function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) IS_MEMBER_OF function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The IS_MEMBER_OF row function takes an atomic value and a set, and returns a Boolean indicating whether the atomic value occurs in the set. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) SINGLETON function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) SINGLETON function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The SINGLETON function takes a single atomic value and returns a set containing only that value. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) SUBSET function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) SUBSET function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The SUBSET row function takes two sets of the same data type and returns a Boolean true if (and only if) the second set is a subset of the first set. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) TRUNCATE_SET function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) TRUNCATE_SET function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The TRUNCATE_SET row function takes a set and an integer, and returns a copy of the set with no more than the specified number of elements in it. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) UNION function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) UNION function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The UNION row function takes two sets of the same data type and returns a set that is the union of both input sets. (shortdesc] (topicmeta] (topicref] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Set constructor (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) Set constructor (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) EQL allows users to write sets directly in queries. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Quantifiers (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) Quantifiers (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) EQL provides existential and universal quantifiers for use with Boolean expressions against sets. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Grouping by sets (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) Grouping by sets (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) EQL provides support for grouping by sets. (shortdesc] (topicmeta] (topicref] (topicref]
(map]