Re: strange behaviour

"Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> "Gaetano Mendola" <mendola@bigfoot.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