Paul Ramsey <pramsey(at)cleverelephant(dot)ca> writes:
> On Feb 26, 2019, at 2:19 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> What's the query look like exactly? The other two calls will occur
>> anyway, but SupportRequestIndexCondition depends on the function
>> call's placement.
> select geos_intersects_new(g, 'POINT(0 0)') from foo;
Right, so that's not useful for an index scan. Try
select * from foo where geos_intersects_new(g, 'POINT(0 0)').
regards, tom lane