Re: Static functions - Mailing list pgsql-general

From Tom Lane
Subject Re: Static functions
Date
Msg-id 17695.1223090398@sss.pgh.pa.us
Whole thread Raw
In response to Re: Static functions  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Responses Re: Static functions  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Re: Static functions  (Joseph S <jks@selectacast.net>)
List pgsql-general
"Gurjeet Singh" <singh.gurjeet@gmail.com> writes:
> Shouldn't PG make all efforts to not execute something when the result is
> already known?

Not if said effort would cost more than is saved, which would be by far
the most likely result if we tried to cache all function results.

            regards, tom lane

pgsql-general by date:

Previous
From:
Date:
Subject: ST_Intersects vs. ST_Touches
Next
From: "Gurjeet Singh"
Date:
Subject: Re: Static functions