Re: [PERFORM] IMMUTABLE?

2006-05-15 Thread Tom Lane
David Wheeler <[EMAIL PROTECTED]> writes: > 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,

Re: [PERFORM] IMMUTABLE?

2006-05-15 Thread David Wheeler
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 tel

Re: [PERFORM] IMMUTABLE?

2006-05-15 Thread Tom Lane
David Wheeler <[EMAIL PROTECTED]> writes: > So, what gives? Am I missing something, or not understanding how > IMMUTABLE works? The latter. regards, tom lane ---(end of broadcast)--- TIP 5: don't forget to increase your fr

[PERFORM] IMMUTABLE?

2006-05-15 Thread David Wheeler
Performance Folks, I just had an article[1] published in which I demonstrated recursive PL/pgSQL functions with this function: CREATE OR REPLACE FUNCTION fib ( fib_for int ) RETURNS integer AS $$ BEGIN IF fib_for < 2 THEN RETURN fib_for; END IF; RETURN fib(fib_for - 2)

Re: [PERFORM] Wrong plan for subSELECT with GROUP BY

2006-05-15 Thread Simon Riggs
On Fri, 2006-05-12 at 10:05 -0400, Tom Lane wrote: > Antal Attila <[EMAIL PROTECTED]> writes: > > If this is a deficiency of the planner, I'd like to suggest this feature > > into the planner. > > This really falls into the category of "you've got to be kidding". Agreed > There's no way that it