Re: pl/pgsql functions outperforming sql ones?

2012/1/31 Carlo Stonebanks <stonec.register@sympatico.ca>:
> Pavel, thank you very much for your explanation.
>
> Is it possible to define under what conditions that sql procs will
> outperform plpgsql ones, and vice-versa?

yes, little bit :)

when inlining is possible, then SQL function will be faster - typical
use case is simple scalar functions (with nonvolatile real
parameters).

Regards

Pavel

>
> -----Original Message-----