Doubt about an array function [Question]

[bocher]

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

[Noel Grandin]

if you make the ALIAS DETERMINISTIC it should cache results to some extent

--
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 h2-database...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3731e4b1-77d5-4807-9064-7729de977f14%40googlegroups.com.

[Carlos Eduardo Lopez Olvera]

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 h2-da...@googlegroups.com.

[bocher]

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 <erwan...@gmail.com> 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 h2-da...@googlegroups.com.