>> 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