Author: turnstep
Date: Sun Jul 20 20:25:58 2008
New Revision: 11550
Modified:
DBD-Pg/trunk/Pg.pm
Log:
More doc tweaks and rearrangements.
Modified: DBD-Pg/trunk/Pg.pm
==============================================================================
--- DBD-Pg/trunk/Pg.pm (original)
+++ DBD-Pg/trunk/Pg.pm Sun Jul 20 20:25:58 2008
@@ -1705,7 +1705,7 @@
This documentation describes driver specific behavior and restrictions. It is
not supposed to be used as the only reference for the user. In any case
-consult the L<DBI|DBI> documentation first!
+consult the L<DBI> documentation first!
=head1 THE DBI CLASS
@@ -2142,7 +2142,9 @@
=item B<CachedKids> (hash ref)
-Implemented by DBI, no driver-specific impact.
+Returns a hashref of handles. If called on a database handle, returns all statement handles created by use of the
+C<prepare_cached> method. If called on a driver handle, returns all database handles created by the C<connect_cached>
+method.
=item B<Executed> (boolean, read-only)
@@ -2242,41 +2244,29 @@
=over 4
-=item B<selectrow_array>
-
- @row_ary = $dbh->selectrow_array($statement, \%attr, @bind_values);
-
-Implemented by DBI, no driver-specific impact.
-
-=item B<selectrow_arrayref>
-
- $ary_ref = $dbh->selectrow_arrayref($statement, \%attr, @bind_values);
-
-Implemented by DBI, no driver-specific impact.
-
-=item B<selectrow_hashref>
-
- $hash_ref = $dbh->selectrow_hashref($statement, \%attr, @bind_values);
-
-Implemented by DBI, no driver-specific impact.
-
=item B<selectall_arrayref>
- $ary_ref = $dbh->selectall_arrayref($statement, \%attr, @bind_values);
+ $ary_ref = $dbh->selectall_arrayref($sql);
+ $ary_ref = $dbh->selectall_arrayref($sql, \%attr);
+ $ary_ref = $dbh->selectall_arrayref($sql, \%attr, @bind_values);
-Implemented by DBI, no driver-specific impact.
+See the DBI documentation for full details. Returns a reference to an array containing the rows returned
+by preparing and executing the SQL string.
=item B<selectall_hashref>
- $hash_ref = $dbh->selectall_hashref($statement, $key_field);
+ $hash_ref = $dbh->selectall_hashref($sql, $key_field);
-Implemented by DBI, no driver-specific impact.
+See the DBI documentation for full details. Returns a reference to a hash containing the rows
+returned by preparing and executing the SQL string.
=item B<selectcol_arrayref>
- $ary_ref = $dbh->selectcol_arrayref($statement, \%attr, @bind_values);
+ $ary_ref = $dbh->selectcol_arrayref($sql, \%attr, @bind_values);
-Implemented by DBI, no driver-specific impact.
+See the DBI documentation for full details. Returns a reference to an array containing the first column
+from each rows returned by preparing and executing the SQL string. It is possible to specify exactly
+which columns to return.
=item B<prepare>
@@ -2949,6 +2939,35 @@
Stop server logging to a previously opened file.
+=item B<selectrow_array>
+
+ @row_ary = $dbh->selectrow_array($sql);
+ @row_ary = $dbh->selectrow_array($sql, \%attr);
+ @row_ary = $dbh->selectrow_array($sql, \%attr, @bind_values);
+
+Returns an array of row information after preparing and executing the provided SQL string. The rows are returned
+by calling L</fetchrow_array>. The string can also be a statement handle generated by a previous prepare. Note that
+only the first row of data is returned. If called in a scalar context, only the first column of the first row is
+returned. Because this is not portable, it is not recommended that you use this method in that way.
+
+=item B<selectrow_arrayref>
+
+ $ary_ref = $dbh->selectrow_arrayref($statement);
+ $ary_ref = $dbh->selectrow_arrayref($statement, \%attr);
+ $ary_ref = $dbh->selectrow_arrayref($statement, \%attr, @bind_values);
+
+Exactly the same as L</selectrow_array>, except that it returns a reference to an array, by internal use of
+the L</fetchrow_arrayref> method.
+
+=item B<selectrow_hashref>
+
+ $hash_ref = $dbh->selectrow_hashref($sql);
+ $hash_ref = $dbh->selectrow_hashref($sql, \%attr);
+ $hash_ref = $dbh->selectrow_hashref($sql, \%attr, @bind_values);
+
+Exactly the same as L</selectrow_array>, except that it returns a reference to an hash, by internal use of
+the L</fetchrow_hashref> method.
+
=back
=head2 Database Handle Attributes
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.