|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/plperl.sgml,v 2.68 2008/03/28 00:21:55 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/plperl.sgml,v 2.69 2008/04/10 15:16:46 alvherre Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="plperl"> |
4 | 4 | <title>PL/Perl - Perl Procedural Language</title> |
@@ -309,20 +309,7 @@ BEGIN { strict->import(); } |
309 | 309 |
|
310 | 310 | <para> |
311 | 311 | Access to the database itself from your Perl function can be done |
312 | | - via the function <function>spi_exec_query</function> described |
313 | | - below, or via an experimental module |
314 | | - <ulink url="http://www.cpan.org/modules/by-module/DBD/APILOS/"> |
315 | | - <literal>DBD::PgSPI</literal></ulink> |
316 | | - (also available at <ulink url="http://www.cpan.org/SITES.html"> |
317 | | - <acronym>CPAN mirror sites</></ulink>). This module makes available a |
318 | | - <acronym>DBI</>-compliant database-handle named |
319 | | - <varname>$pg_dbh</varname> that can be used to perform queries with |
320 | | - normal <acronym>DBI</> |
321 | | - syntax.<indexterm><primary>DBI</></indexterm> |
322 | | - </para> |
323 | | - |
324 | | - <para> |
325 | | - PL/Perl provides additional Perl commands: |
| 312 | + via the following functions: |
326 | 313 |
|
327 | 314 | <variablelist> |
328 | 315 | <varlistentry> |
@@ -412,6 +399,7 @@ $$ LANGUAGE plperl; |
412 | 399 | SELECT * FROM test_munge(); |
413 | 400 | </programlisting> |
414 | 401 | </para> |
| 402 | + |
415 | 403 | <para> |
416 | 404 | <literal>spi_query</literal> and <literal>spi_fetchrow</literal> |
417 | 405 | work together as a pair for row sets which might be large, or for cases |
|