New operators SUBSET and INTERSECT - Caveat

The SQL operators SUBSET and INTERSECT were added in version 7, for set-like queries on strlst values. SUBSET is true if and only if all left-side value(s) are present on the right side; INTERSECT is true if any left-side values are present on the right.

SUBSET and INTERSECT are new keywords in Texis version 7. If either is already in use (in all-upper or all-lower case) as an identifier - table name, column name, index name, etc. - then its usage must be enclosed in double-quotes in SQL in version 7, to prevent syntax errors. E.g.: SELECT "subset" FROM MyTable ...


Copyright © Thunderstone Software     Last updated: Oct 24 2023
Copyright © 2024 Thunderstone Software LLC. All rights reserved.