See DBD::PgSPI on CPAN, or www.formenos.org/PgSPI
Example:
create function dbd_pgspi_test() returns varchar as '
use DBD::PgSPI;
my @ar=$pg_dbh->selectrow_array(''select current_user'');
return $ar[0];
' language 'plperlu';
Currently, it does not support triggers. (Well, it supports triggers, but
there's no way to access trigger arguments).
On Wed, 24 Oct 2001, Gordan Bobic wrote:
> Hi.
>
> How do I manipulate data in tables from within plperl? Can I, for example,
> issue SQL statements from within plperl functions? I haven't managed to find
> any documentation on this subject. Can anyone point me in the correct
> direction, please? I'm trying to write some trigger functions...
>
> I have seen an example with the plperl function that performs a calculation
> on each row of a table, but it is not explained anywhere how to insert
> records, or how to locate specific records without having to loop through the
> entire database. I presume that DBI will not work, given the need for setting
> up separate database connections, authentication, etc.
>
> Thanks.
>
> Gordan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
