Re: Functions in Postgres

Tom Lane wrote:
> Jan Wieck <janwieck(at)yahoo(dot)com> writes:
> > Tom Lane wrote:
> >> Not since about Tcl 8.0.
>
> > You're right, not Tcl's fault. Noone changed PL/Tcl to use it
> > though. It still does Tcl_CreateCommand(), which is the
> > backward compatibility pure string interface wrapping
> > technology. :-)
>
> I could be mistaken, but I thought Tcl would still reduce the function
> text to bytecode behind-the-scenes.
>
> We are losing with unnecessary text conversions in a number of places in
> pltcl, but I think it's just in parameter passing at pltcl function
> entry/exit and calls to the special Tcl commands provided by pltcl.
> If you're executing regular Tcl commands inside a pltcl function,
> I think you still will get benefit from Tcl 8's speedups.

Absolutely. It's only all the SPI_* crap and parameter/result
conversion. Inside Tcl it's calm like in the center of a
hurricane, the problem is just getting in and out...

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 #