"Tom Lane" <[EMAIL PROTECTED]> wrote: > "Gaetano Mendola" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
