I've been trying to track that down also. I haven't found any documentation on
how to do queries in plperl, but I have looked at the plperl.c code and it
appears that it uses the SPI interface to do queries. In any case, the
documentation is rather quite lacking. Does anyone know any good examples in
plperl that does queries?
Wade Oberpriller
>
> > I ran into these same errors with Perl-5.6.0. Has anyone built PLPerl with
> > Perl-5.6.0? (I ended up going back to Perl 5.005_03).
> >
> > Wade Oberpriller
> >
>
> I use Postgres 7.0.3, perl 5.6.0
>
> For perl:
> ./Configure -Duseshrplib -des
> make
> make test
> make install
>
> For plperl:
> perl Makefile.PL POLLUTE=1
> make
> make install
>
> It's OK for simple function, but I don't know how:
> 1) call sql statement ( such as 'select ...' and so on ) from plperl
> 2) change limit ( how controle, drive ) of plperl possibility ( plperl limit )
>
> If you know answer to my 2 questions, please, send me e-mail.
> If you have file with pl/perlsql ( pl/perlsql examples ), please, send me files.
>
> turing2000
>
>
