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
