Paul Ramsey <pram...@cleverelephant.ca> writes: > On Feb 26, 2019, at 2:19 PM, Tom Lane <t...@sss.pgh.pa.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