On Fri, 03 Oct 2008, Joseph S <jks@xxxxxxxxxxxxxxx> writes: > Aren't static functions supposed to executed only once per transaction? There is no such promise, that depends on the PL you prefer. For instance, in PL/scheme[1] non-volatile (immutable) and non-SRF functions are cached per (top) transaction. Regards. [1] http://plscheme.projects.postgresql.org/