Set-like Searches Using IN, SUBSET and INTERSECT

The IN, SUBSET and INTERSECT operators can be used for set-like searches on multi-value type fields such as strlst. For example, to find rows where a query term is present in a strlst column, use IN. To find rows where a strlst column contains any of a list of query terms, use INTERSECT to find the set intersection of the row and the query set. To find rows where all query terms must be present in the row, use SUBSET.



Copyright © Thunderstone Software     Last updated: Apr 15 2024
Copyright © 2024 Thunderstone Software LLC. All rights reserved.