Re: pl/Perl - Mailing list pgsql-sql

From Tom Lane
Subject Re: pl/Perl
Date
Msg-id 12092.982789481@sss.pgh.pa.us
Whole thread Raw
In response to Re: pl/Perl  (Jie Liang <jliang@ipinc.com>)
Responses Urgent help  (Jie Liang <jliang@ipinc.com>)
sysfile cruptted?  (Jie Liang <jliang@ipinc.com>)
Re: pl/Perl  (Jie Liang <jliang@ipinc.com>)
List pgsql-sql
Jie Liang <jliang@ipinc.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


pgsql-sql by date:

Previous
From: Daniel Wickstrom
Date:
Subject: Re: now() with microsecond granulity needed
Next
From: Tom Lane
Date:
Subject: Re: now() with microsecond granulity needed