var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: materilized view question
is it possible to build materilized view which consist group by query
of some table but when it refreshing it will keep the old data which store
in it and will update the new one ?
for example i have a group by query which take statistics on some table every month.
I need that the materilized view will store the statistics and will keep the old resault.
No, a materialized view can only store the "current" results of its defining query. You will need to maintain this history yourself.