"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