Re: [SQL] Function Volatility

[Fernando Hevia]

Tom Lane writes:

> The IMMUTABLE marker is a promise from you to the system that it is safe
> to optimize away multiple calls to the function.  It is not a promise
> from the system to you that the system will expend unlimited amounts of
> energy to detect duplicate calls.

Nicely put. Thanks!
BTW, this explanation should go into the manual.

Regards,
Fernando.


---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [SQL] postgresql HEAD build failure

[Erik Jones]

On Sep 9, 2007, at 9:51 PM, Tom Lane wrote:


John Summerfield <[EMAIL PROTECTED]> writes:

-d fixed the missing directories
and -P prunes obsolete ones.



Obviously I needed to read the instructions more closely:-(


FWIW, I've used the following ~/.cvsrc for many years:

cvs -z3
update -d -P
checkout -P

The usefulness of -z3 depends on the speed of your connection, but
the other two lines fix obviously stupid defaults ...

regards, tom lane


Heh, most of the people I know who use Subversion made the switch  
just because of the need for those two lines.  (Of course, repository- 
wide versioning another common reason.)


Erik Jones

Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com



---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq