Dear all, I have the following sql query
CREATE VIEW geomColumns as select t[0] as geometry_type, t[1] srid FROM (SELECT findmetadata(COLUMN_TYPE) AS t from FROM INFORMATION_SCHEMA.COLUMNS WHERE TYPE_NAME = 'GEOMETRY') where findmetadata return an array of values Is there a way to cache the result of the findmetadata function and avoid multiple calls in the main select query ? Regards -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3731e4b1-77d5-4807-9064-7729de977f14%40googlegroups.com.
