Re: Functions in Postgres

On Wed, 10 Apr 2002, Peter Eisentraut wrote:

> Each language handler is free to interpret the source text in its own way.
> This has nothing to do with trustedness (is SQL not trusted?). Neither
> PL/pgSQL nor PL/Tcl involve a compilation step, although PL/pgSQL does
> some optimizations internally that could be called compilation.
>
> Is this question just out of random interest, or are you really asking
> something like are functions fast?

I was asking to see if there was any speed penalty with coding a fn in SQL
as opposed to PL/pgsql. It appears that there is and from what you've said
PL/pgsql is slightly faster than PL/TCL and probably PL/Perl. Am I correct
in drawing that conclusion?

Thanks for your help.

--
Cheers...Gordon
-------------+------------------------------------------------------------
ADF Aircraft | Cataloguing the serial numbers of Australian Defence Force
Serial | aircraft for all the three series.
Numbers | http://www.adf-serials.com
-------------+------------------------------------------------------------