|
1 | 1 | <!--
|
2 |
| -$PostgreSQL: pgsql/doc/src/sgml/plperl.sgml,v 2.28 2004/09/20 22:48:25 tgl Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/plperl.sgml,v 2.29 2004/10/15 16:51:48 momjian Exp $ |
3 | 3 | -->
|
4 | 4 |
|
5 | 5 | <chapter id="plperl">
|
@@ -260,7 +260,9 @@ composite types.
|
260 | 260 | </para>
|
261 | 261 |
|
262 | 262 | <para>
|
263 |
| - Here is an example of a PL/Perl function returning a rowset of a row type: |
| 263 | + Here is an example of a PL/Perl function returning a rowset of a |
| 264 | + row type. Note that a composite type is always represented as a |
| 265 | + hash reference. |
264 | 266 | <programlisting>
|
265 | 267 | CREATE TABLE test (
|
266 | 268 | i int,
|
@@ -305,7 +307,10 @@ $$ LANGUAGE plperl;
|
305 | 307 | </para>
|
306 | 308 |
|
307 | 309 | <para>
|
308 |
| - Here is an example of a PL/Perl function returning a rowset of a composite type. |
| 310 | + Here is an example of a PL/Perl function returning a rowset of a |
| 311 | +composite type. As a rowset is always a reference to an array |
| 312 | +and a composite type is always a reference to a hash, a rowset of a |
| 313 | +composite type is a reference to an array of hash references. |
309 | 314 | <programlisting>
|
310 | 315 | CREATE TYPE testsetperl AS (f1 integer, f2 text, f3 text);
|
311 | 316 |
|
|