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 ([EMAIL PROTECTED]) 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 > [EMAIL PROTECTED] > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl