Postgres Pro
Downloads
Home   >   mailing lists

Re: Prepare plan in plpgsql - Mailing list pgsql-sql

From Tom Lane
Subject Re: Prepare plan in plpgsql
Date
Msg-id 29930.1120679759@sss.pgh.pa.us
Whole thread Raw
In response to Prepare plan in plpgsql  (Jocelyn Turcotte <turcotte.j@gmail.com>)
List pgsql-sql
Tree view 
Jocelyn Turcotte <turcotte.j@gmail.com> 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

pgsql-sql by date:

Previous
From: Jocelyn Turcotte
Date:
Subject: Prepare plan in plpgsql
Next
From: Ragnar Hafstað
Date:
Subject: Re: left joins