(Materialised) Views functionality

[tre...@gmail.com]

Hi all,

I was wondering if it's possible to somehow replicate materialised view functionality from Postgres and other SQL databases. 

So essentially, creating a GTS that is not really stored but more of an alias for a warp script that returns GTS but still acts as a GTS. Materialization is a bonus.

If that's not possible, what would be the best way to create a GTS from many other GTSes?

Underlying problem is that there are low-level GTS that are put together in aggregate that will be most interesting for the user.  I want to abstract low-level GTSes. 

Many thanks,

Sebastjan

[Mathias Herberts]

Hi,

the best way is probably to deploy a macro server side which will return those synthetic GTS given input parameters.