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