I think this is problematic with the default compilation fo PL/Perl.
The perl interpretor you get in a plperl function is inside of a
"sandbox" (can't remember the official name) where it is limited
to only a relatively small set of functions. I don't think that
SQL commands are included.
--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------
Hitesh Patel (hitesh@presys.com) wrote:
> I need to be able to execute SQL commands from inside a plperl function and
> can't figure if I can do this. Also.. after executing the query I need to be
> able to grab the number of tuples returned and there values.. how would I go
> about doing this.. any help would be appreciated.
>
> --
> Hitesh Patel
> hitesh@presys.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html