shawn everett <everett(at)pgweb(dot)com> writes:
> The basic select statement for my problem is going to work as follows:
> select colA, colB, colA+colB*0.4 as f1, colC, colC+colD*9 as f2 from table
> where date=SomeDateEnteredByTheUser;
OK, no problem:
create view myview as
select date, colA, colB, colA+colB*0.4 as f1, colC, colC+colD*9 as f2
from table;
Then your app does
select * from myview where date = SomeDateEnteredByTheUser;
(if you don't want to include the date in the display, you can't
just write * for the output columns, but hopefully you get the
idea now...)
regards, tom lane