Re: Learning Plpgsql ??

From: Jonathon Batson <jonathon(at)octahedron(dot)com(dot)au>
To: Steve_Miller(at)sil(dot)org, Postgres Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Learning Plpgsql ??
Date: 2003-01-28 22:59:01
Message-ID: 3E370B35.6020900@octahedron.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Taken from Postgres 7.3 Docs

19.5.4. Executing dynamic queries

"Unlike all other queries in PL/pgSQL, a query run by an EXECUTE
statement is not prepared and saved just once during the life of the
server. Instead, the query is prepared each time the statement is run."

To me this means that 'yes' a new execution plan is produced each time.

>
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sumaira Ali 2003-01-28 23:24:30 JDBC
Previous Message David Nicely 2003-01-28 22:56:34 Re: New and investigating