On Sat, Oct 4, 2008 at 1:36 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
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
Joseph S <jks@xxxxxxxxxxxxxxx> writes:There's no promise of that.
> Aren't static functions supposed to executed only once per transaction?
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