"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.
regards, tom lane