Re: strange behaviour - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: strange behaviour
Date
Msg-id 00d001c1ee0e$d314e7c0$d5a9fea9@GMENDOLA2
Whole thread Raw
In response to strange behaviour  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
"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


pgsql-admin by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: smart copy?
Next
From: Jane Richards
Date:
Subject: How do I get encrypted password access from a cgi application