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

Status

Assignee

Mauro Bartolomeoli

Reporter

Mauro Bartolomeoli

Triage

None

Components

Affects versions

22.0

Priority

Medium
Configure