Maximilian Tyrtania writes:
> Quite often i find myself reluctant to nest views, because of the
> maintenance issues this usually involves. As you know, you can't easily
> alter the "lower level" views, because the higher level ones depend on them.
> So, to add a field to a lower level view one ha
Quite often i find myself reluctant to nest views, because of the
maintenance issues this usually involves. As you know, you can't easily
alter the "lower level" views, because the higher level ones depend on them.
So, to add a field to a lower level view one has to:
drop view vw_lowlevel CASCADE;