On Sat, Oct 4, 2008 at 1:36 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Joseph S <jks(at)selectacast(dot)net> writes:
> > Aren't static functions supposed to executed only once per transaction?
>
> There's no promise of that.
>
Can this be changed? Or does it work only in simpler queries, based on some
result-caching criteria?
Shouldn't PG make all efforts to not execute something when the result is
already known?
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device