Earlier, I wrote:
> Exactly what is gained by the use of persistent prepare over the use of
> a stored procedure?
Er, ENOCOFFEE. Sorry.
The benefit is obvious with use of global prepared statements at the
wire protocol level rather than via SQL EXECUTE . It's a lot more
efficient than EXECUTE or SELECT function(params).
It's pretty clear that there are some tricky aspects though, what with
schema search paths, role priveleges, etc.
--
Craig Ringer