Re: do functions cache views?

> This is hard to believe.

i don't want to believe it. trust me.

> I am not sure that "if not found" means anything after a "select max()"
> query. The select will always return exactly one row --- even if it's
> just a NULL --- so I'd expect the "if not found" never to succeed.
> Perhaps you want to be testing whether v_significant_date is NULL or
> not, instead.

i wasn't sure if this would work. i actually changed it to this after
trying just a straight null check. i'll change it back to that, and see
if i still experience the same problem. that may have been back when i
was still running 7.0.3 or an early 7.1 beta.

speaking of which, how is "found" functionality supposed to work?

> Another issue, since you omitted the details of the view and of what
> version you are running, is whether the view involves GROUP BY and/or
> aggregates. An aggregate over a grouped view won't work properly in
> versions before 7.1.

this shouldn't be an issue since i'm running 7.1.

> If it's not those issues then we'll need more details --- preferably
> a self-contained example.

i'll try removing the "if not found" code and see what happens.

thanks.

-tfo