Jie Liang <jliang(at)ipinc(dot)com> writes:
> My choice:
> if involving a lot of regular expressions, pl/Perl is better;
> if involving a lot of SQLs or other functions(or store procedures),
> then pl/pgsql is better.
Also consider pltcl, which has pretty nearly perl-equivalent regexp
support, and can do queries too. Besides which it's easier to build/
install than plperl.
It's a shame that plperl doesn't yet have support for making queries.
It hasn't really progressed much past the proof-of-concept stage IMHO,
but no one is working on it :-(
regards, tom lane