Re: Which is faster SQL or PL/PGSQL - Mailing list pgsql-sql

Joe,

> Yes, I believe so (well, actually the optimizer). An inlined SQL
> function ends up behaving like a macro that expands at run time and is
> therefore quite fast -- no function call overhead at all.

... but only in 7.4.   In 7.2 and I think in 7.3 this was not implemented.

While we're on the topic, anyone know any good ways to speed up EXECUTE
statements in PL/pgSQL functions?

--
-Josh BerkusAglio Database SolutionsSan Francisco