[
https://issues.jboss.org/browse/TEIID-3792?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3792:
---------------------------------------
Updated the parser and other logic to allow quantified comparison with arrays -
expression operator ALL|SOME (array_expression)
for now this just reused the SubqueryCompareCriteria. This is full support rather than a
rewrite to an intermediate form using array_iterate as it will be easier to determine
pushdown in this form. However pushdown support was not yet added, but is supported for
example by postgresql.
Add support for searching in array types
----------------------------------------
Key: TEIID-3792
URL:
https://issues.jboss.org/browse/TEIID-3792
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.0
We should support a simple syntax for searching within an array, such as the quantified
comparison and/or a function to get the index of a value in an array.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)