Re: [SQL] Prepare plan in plpgsql

2005-07-06 Thread Tom Lane
Jocelyn Turcotte <[EMAIL PROTECTED]> writes: > i'm wondering if there is a way to prepare and execute a plan in a > plpgsql function. You do not need that because plpgsql automatically caches plans for SQL statements appearing in a plpgsql function. regards, tom lane

[SQL] Prepare plan in plpgsql

2005-07-06 Thread Jocelyn Turcotte
Hi, i'm wondering if there is a way to prepare and execute a plan in a plpgsql function. The prepare seems to work as expected but obviously the execute plan_name(...) statement is interpreted as the plpgsql execute keyword and says me that the plan_name function don't exists is there a way to us