Re: strange behaviour

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Gaetano Mendola" <mendola(at)bigfoot(dot)com> writes:
> > It is normal that inside sp_foo() the sp_now() is not anymore called ?
>
> You *did* mark it cachable. timeofday() is pretty much the classic
> example of functions that shouldn't be marked cachable.

Yes I know, but is not so clear why in a select like:

select sp_now(), sp_foo();

the first call to sp_now() is not cached and inside sp_foo() yes,
this behaviour was more clear for me if both sp_now() was
cached.

Ciao
Gaetano