Materialized view in Postgres from the variables rather than SQL query results

I have a stored procedure in Postgres. I have generated some variables in that procedure. These variables are generated inside a loop of query result. Suppose if i have 10 rows from my query then for 10 times I am generating those variables. Now I want to create a materialized view where these var

Re: Materialized view in Postgres from the variables rather than SQL query results

a more > appropriate list - specifically the -general list. > > David J. > > > On Thursday, November 30, 2023, Nurul Karim Rafi > wrote: > >> I have a stored procedure in Postgres. I have generated some variables in >> that procedure. These variables are generated inside a