Re: pl/Perl

FYI,

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. 

Jie LIANG

St. Bernard Software
Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

On Wed, 21 Feb 2001, Jeff MacDonald wrote:

> > > 1: can you call other stored procedures from within pl/Perl
> > No.
> 
> darn.
> 
> > 
> > > 2: from within a pl/Perl script , can i do a select etc..
> > >    i'm assuming no, because you cannot use DBI.. but just wondering
> > >    if there is a way..
> > Not currently.
> 
> darn.
> 
> > > 3: installing it.. i installed postgres 7.0.3 from ports on my fbsd system.
> > >    when i tried to install pl/perl i get this..
> > > 
> > > cd /usr/ports/databases/postgresql7/work/postgresql-7.0.2/src/pl/plperl/
> > > perl Makefile.pl
> > > make
> > Try using gmake instead of make (cd /usr/ports/devel/gmake, make)
> 
> thanks ! works great.
> 
> 
> Jeff MacDonald,
> 
> -----------------------------------------------------
> PostgreSQL Inc        | Hub.Org Networking Services
> jeff@pgsql.com        | jeff@hub.org
> www.pgsql.com        | www.hub.org
> 1-902-542-0713        | 1-902-542-3657
> -----------------------------------------------------
> Facsimile : 1 902 542 5386
> IRC Nick  : bignose
> PGP Public Key : http://bignose.hub.org/public.txt
>