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
>
