Hi,
Inside a stored procedure EXECUTE runs a dynamic query,
DOCS SAY:
Oftentimes you will want to generate dynamic commands inside your
PL/pgSQL functions, that is, commands that will involve different tables
or different data types each time they are executed. PL/pgSQL's normal
attempts to cache plans for commands will not work in such scenarios. To
handle this sort of problem, the EXECUTE statement is provided:
EXECUTE command-string;
where command-string is an expression yielding a string (of type text)
containing the command to be executed. This string is fed literally to
the SQL engine.
Really not sure how to execute a named plan inside plpgsql.
Regds
mallah.
Rajat Katyal wrote:
Hi:
I prepare the statement for execution as follows:
*PREPARE query(text) as SELECT count(*) FROM
transform_customer_billing where inv_no = $1;*
**
The problem is Iam not able to execute this prepare statement from
the stored procedure defined. I added the statement to call the
prepare statement is: *EXECUTE query('100023'). *The ERROR it prints :
*Function query(text) does not exist.*
Please suggest the solution for this problem.
Thanks in advance.
Rajat