Postgres Pro
Downloads
Home   >   mailing lists

Re: Static functions - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: Static functions
Date
Msg-id 65937bea0810031751o66704a35p5444e0322084539c@mail.gmail.com
Whole thread Raw
In response to Re: Static functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Static functions
List pgsql-general
Tree view
On Sat, Oct 4, 2008 at 1:36 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Joseph S <jks@selectacast.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[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

Mail sent from my BlackLaptop device

pgsql-general by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: failed to install posgrest
Next
From: Martin Gainty
Date:
Subject: Re: Standalone Windows Installation