Re: plperl vs plpgsql

On 2005-04-17 14:56, Alex wrote:
> Is there a performance difference between the two?

As Christopher already pointed out, it depends on what you want to do.
If you're doing some complex string processing, it will be easier (and
in some cases) faster to do in plperl, if you're mainly dealing with
sets, plpgsql will be better suited.

> which of the PL is most widely used.

plpgsql.

> One problem i have with the plpgsql
> is that the quoting is really a pain.

In current versions of PostgreSQL you can use $$ quoting, which should
make your life easier:
http://www.postgresql.org/docs/8.0/static/plpgsql-structure.html
http://www.postgresql.org/docs/8.0/static/plperl.html


HTH,
stefan