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@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
