Re: Functions in Postgres

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 (if memory 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(at)Yahoo(dot)com #