do views cache functions? (was Re: do functions cache views?)

 
>> If it's not those issues then we'll need more details --- preferably
>> a self-contained example.
> 
> 
> ok. here are some more details:
> 
> the only other thing that might cause a problem with the view that i can 
> see is that there is a part of the where clause that references 
> CURRENT_DATE.
> 
> as in:
> 
> create view significant_records_view as
> select *
> from significant_records sr
> where sr.significant_date <= CURRENT_DATE
> -- rest of where clause
> ;
> 
> now, this function is used in a date-sensitive context. could the 
> function in my original example, which references this view, be caching 
> the view as of the last CURRENT_DATE on which the function was brought 
> into being?

in which case, maybe the more appropriate question is:

do views cache functions?

-tfo