"Matthew Dennis" <[EMAIL PROTECTED]> writes:
> Do SQL statements inside of plpgsql functions get planned upon every
> execution, only when the function is first executed/defined, or something
> else entirely?
First executed per session.
> Now, when bar is executed again, will PG (8.3.1) know th
On Sun, Apr 27, 2008 at 2:06 AM, Matthew Dennis <[EMAIL PROTECTED]> wrote:
> Do SQL statements inside of plpgsql functions get planned upon every
> execution, only when the function is first executed/defined, or something
> else entirely?
They are planned on first execution and the plan is cached