Re: [GENERAL] Create one prepared function

2006-01-07 Thread Neil Conway
On Sun, 2006-01-08 at 00:12 +, Marcos José Setim wrote: > I'd like that create functions in plpgsql with prepared SQL and plan > saved, to that the Postgresl increase the performance of executions. > > This is possible? plpgsql internally caches query plans the first time a function is invoke

[GENERAL] Create one prepared function

2006-01-07 Thread Marcos José Setim
Hi, I'd like that create functions in plpgsql with prepared SQL and plan saved, to that the Postgresl increase the performance of executions. This is possible? I would like to see a simple example of use this, if this is possible, i find for examples in the google, but the joined result is littl