I have a table (call it T1) made up of a join from two other tables
and a few calculated columns.
Currently, T1 gets refreshed by manually calling a function that does
the select on the join and then loops through each row doing an
update / insert as needed.
Obviously it would be nice to put this in a view so that I don't
have to worry about someone forgetting to call the refresh function.
My question (probably a common one):
When I select a single row from the view using WHERE will
the view build the calculated columns for every row regardless?
pgsql-novice by date
|Next:||From: Andreas Kretschmer||Date: 2006-03-02 18:22:45|
|Subject: Re: Efficiency of Views|
|Previous:||From: George Weaver||Date: 2006-03-02 16:31:27|
|Subject: Re: pg_config --pgxs|