I know function table but this lead to modifying the sql request and it is not in standard.
Le mardi 21 mai 2013 11:52:15 UTC+2, Noel Grandin a écrit : > > 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] <javascript:>. > To post to this group, send email to [email protected]<javascript:> > . > 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.
