Re: Static functions

On Sat, Oct 04, 2008 at 08:30:32PM -0400, Joseph S wrote:
> In this case, with the function being called over and over again inside
> a nested loop, it would be worth the effort. I'm not even talking about
> caching the result for the whole transaction block, just replacing the
> function call before continuing the query.

I think you're going to have to be more specific, because if the
function is stable or immutable, pg will do exactly as you say. Post
the actual query involved.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.