Add support for ANY clause optimization in PostGIS driver

Description

We would like to add support for the ANY/SOME operator of PostgreSQL (https://www.postgresql.org/docs/9.1/functions-comparisons.html), introducing a new FilterFunction (e.g. FilterFunction_any) that will be transformed by the jdbc-postgis driver to an expression using the ANY operator.

any(<literal>, <array>)=true --> <literal>=ANY(<array>)

Environment

None

Activity

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created September 24, 2019 at 8:36 AM
Updated January 29, 2020 at 8:56 AM
Resolved January 4, 2020 at 4:51 PM