Peter Eisentraut wrote:
> Gordon Clarke writes:
>
> > 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?
>
> Yes, that seems about right.
I would say it depends pretty much on what that function is doing. PL/pgSQL is not the best answer to
do string manipulation and such. PL/Tcl can do that alot better, Tcl has it's own bytecode compiler since 8.0
(ifmemory serves), and if the programmer cares, it can cache query plans as well. As allways
a) Using the right tool for a problem can lead to good results.
b) A fool with a tool is still a fool.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #