> Bruce Momjian writes:
> > There is an FAQ item on this --- use EXECUTE.
> So I should be using EXECUTE for all access to the temp tables? ie inserts,
> and selects (in this case). Should I use execute for the table creation?
All access from plpgsql functions for temp tables should use EXECUTE,
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2004-04-23 02:06:09|
|Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc |
|Previous:||From: Bruce Momjian||Date: 2004-04-22 23:46:00|
|Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc|