DBIx::PgLink::LocalDBI emulation for local data access in PostgreSQL PL/Perl function | |
Download |
DBIx::PgLink::Local Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Alexey Sharafutdinov
- Publisher web site:
- http://search.cpan.org/~asvbr/
DBIx::PgLink::Local Tags
DBIx::PgLink::Local Description
DBI emulation for local data access in PostgreSQL PL/Perl function DBIx::PgLink::Local is a DBI emulation for local data access in PostgreSQL PL/Perl function.SYNOPSISPostgreSQL script CREATE FUNCTION fn() RETURNS ... LANGUAGE plperlu AS $$ ... use DBIx::PgLink::Local; $q = pg_dbh->prepare( q ); $q->execute("world"); while (my $row = $q->fetchrow_hashref) { elog 'INFO', $row->{foo}; # prints 'Hello, world' } ... $v = pg_dbh->selectrow_array( 'SELECT $1 * $1 as bar', # query string { types=> } ), # attributes 3 # parameter values ); elog 'INFO', $v; # prints '9' ... $$WARNING: this module works only in PostgreSQL functions written in PL/PerlU language in PostgreSQL server version 8.2 or higher.DBIx::PgLink::Local is a wrapper around PL/Perl Server Programming Interface (SPI) functions. Module provides only basic functions of DBI. For full DBI-compatible driver look at DBD::PgSPI.Module manage prepared statements and cache query plans. It is not depend on other DBIx::PgLink code (except DBIx::PgLink::Logger) and can be used in any PL/Perl function. Requirements: · Perl
DBIx::PgLink::Local Related Software