Thanks Noel. Regards Le mercredi 6 mai 2020 18:40:15 UTC+2, Noel Grandin a écrit : > > if you make the ALIAS DETERMINISTIC it should cache results to some extent > > On Wed, 6 May 2020 at 10:58, bocher <[email protected] <javascript:>> > 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] <javascript:>. >> 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/7c08cdda-02b7-4779-bb63-d219de9375fc%40googlegroups.com.
