if you make the ALIAS DETERMINISTIC it should cache results to some extent On Wed, 6 May 2020 at 10:58, bocher <[email protected]> wrote:
> 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 > <https://groups.google.com/d/msgid/h2-database/3731e4b1-77d5-4807-9064-7729de977f14%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAFYHVnU%2Bd3muWkKab1tdK5vdzUzdmjz-8JMA00FxKye8U8ZBTg%40mail.gmail.com.
