On Wed, Mar 18, 2009 at 2:40 PM, Ivan Sergio Borgonovo wrote:
> If the view is just an alias for the SQL as "text" and it is not
> interpreted at creation time...
This assumption is wrong. A view is "compiled" at creation time, and the
compiled version of the view is used in queries.
--
gurje
I've this view:
create or replace view catalog_promosimple_v as
select p.PromoSimpleID,
p.IsPromo, p.Percent, p.OnListPrice, p.Vendible,
p.OnStock, p.Dist, p.PromoStart, p.PromoEnd, pi.ItemID, pi.Discount
from catalog_promosimple p
join catalog_promosimpleitem pi on
pi.PromoSimpleID=
