See the section title "Using a function as a table" here
http://h2database.com/html/features.html#user_defined_functions
On 2013-05-21 10:07, Nicolas Fortin (OrbisGIS) wrote:
Discussion about user defined index on OTHER type.
In spatial SQL the following request on an indexed geometry column
would use spatial index:
select * from spatialTable where ST_Intersects(the_geom,
ST_PolyFromText('POLYGON ((67 13, 67 18, 59 18, 59 13, 67 13))',1));
Usage of ST_Intersects filter the_geom field by using BoundingBox
stored index of the spatialTable, then the method is applied on
filtered rows.
Can I do this by creating my own TableEngine ? There is an easier way
without modifying the sql request ? Maybe a way to let special kind of
function to alter the execution plan ?
Thanks for your support.
--
You received this message because you are subscribed to the Google
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
