Re: choiche of function language was: Re: dynamic procedure call

On May 10, 2008, at 12:14 AM, Ivan Sergio Borgonovo wrote:

> On Sat, 10 May 2008 07:35:36 +0200
> "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
>> your application different execution paths. Generally I can say, so
>> plpgsql isn't well language for this games, and better is using
>> plperl, plpython or other external language.
>
> It is clear what is at least one of the advantage of plpython or
> plperl over plpgsql, but then what are the advantages of plpgsql over
> the rest of the crowd other than resembling the language used in
> Oracle?

A much better impedance match to the database. It's designed for
doing database-ish things. The biggest advantage there is that
your datatypes are the database datatypes and your expression
parser is the sql expression parser. That makes using things like
timestamp or interval or custom database types simpler and cleaner
from pl/pgsql than from, say, pl/perl/

Cheers,
Steve