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