Re: Dynamic prepare possible in plpgsql?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Collin Peters" <cadiolis(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Dynamic prepare possible in plpgsql?
Date: 2007-05-03 05:55:18
Message-ID: 27835.1178171718@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Collin Peters" <cadiolis(at)gmail(dot)com> writes:
> So if I have an INSERT inside a LOOP in a plpgsql function, it is only
> prepared once?

Once per session, yes (barring some special cases like polymorphic
functions and trigger functions, which would get prepared once per
session per calling situation)

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rodrigo De León 2007-05-03 07:17:21 Re: Needs Function
Previous Message Penchalaiah P. 2007-05-03 04:38:49 Needs Function