Re: PL/Perl Question - Mailing list pgsql-general

From Doug McNaught
Subject Re: PL/Perl Question
Date
Msg-id m31yqnzugi.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to PL/Perl Question  (Hitesh Patel <hitesh@presys.com>)
List pgsql-general
Hitesh Patel <hitesh@presys.com> writes:

> 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.

As I understand it, PL/Perl doesn't currently have an interface to the
server backend, so all you can really do with it is string and number
manipulation.  You'll have to use Tcl or PL/PGSQL for your functions.

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan

pgsql-general by date:

Previous
From: Peter Pilsl
Date:
Subject: Re: problems with pg_dumplo (was Re: backup with blobs)
Next
From: "Vilson farias"
Date:
Subject: Re: very slow execution of stored procedures