Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: IMMUTABLE?



On May 15, 2006, at 20:21, Tom Lane wrote:

So, what gives? Am I missing something, or not understanding how
IMMUTABLE works?

The latter.

Hee-hee! And after all those nice things I wrote about you in a previous email on this list!

But seriously, the documentation says (as if I need to tell you, but I was reading it again to make sure that I'm not insane):

IMMUTABLE indicates that the function always returns the same result when given the same argument values; that is, it does not do database lookups or otherwise use information not directly present in its argument list. If this option is given, any call of the function with all-constant arguments can be immediately replaced with the function value.

So that seems pretty clear to me. Now, granted, the recursive calls to fib() don't pass a constant argument, but I still would think that after the first time I called fib(28), that the next call to fib(28) would be lightening fast, even if fib(27) wasn't.

So, uh, would you mind telling me what I'm missing? I'm happy to turn that knowledge into a documentation patch to help future boneheads like myself. :-)

Thanks,

David



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group