Query for array(string) type fails - or syntax documentation is missing about crate

[dobe]

hi

checking for array containment is currently not supported, but i am glad to report that we just commited this feature in the current sprint. so stay tuned, the feature should be released in about 2 weeks.

we plan to implement the ANY keyword (at least for the "=" operator) the same way that postgres does (see http://www.postgresql.org/docs/9.3/static/functions-comparisons.html)

so your query would then be:

select id,ips,domain from netinfos where '110.76.141.122' = ANY (ips)

[dobe]

hi stefan

we just released 0.37.0 which adds ANY support, see https://crate.io/docs/en/0.37.0/sql/dml.html?highlight=any#any-array

the release is available only in the testing repositories

have fun

[dobe]

closing this issue since it is implemented in testing