I am using PostgreSQL and PostGIS to handle geodata. I have created an index on my geometry column. I have created functions to allow dynamic feature requests within my web application. The functions are based on sql and not plpgsql. Someone now told me that the spatial index cannot be used within functions that are based on sql, but only when using plpgsql.
Is it true, that only functions using plpgsql can use the spatial index?