-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> Before I do that I'd like to be sure DBI/DBD should not support
> non-select statements in selectall_*.
I don't think it should, although we have to be careful about
perhaps differentiating between 'non-select' statements and statements
that do not return 'selectable' data. For example, this is
valid with DBD::Pg:
$SQL = q{INSERT INTO foobar(a) VALUES (123) RETURNING id};
$info = $dbh->selectall_arrayref($SQL);
print "The last insert had an id of $info->[0][0]\n";
But things like CREATE TABLE? Can't see that being allowed. FWIW,
such a statement fails like this on DBD::Pg:
DBD::Pg::db selectall_arrayref failed: no statement executing
- --
Greg Sabino Mullane [email protected]
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201106091607
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAk3xKLcACgkQvJuQZxSWSshatgCgogcTSW2NYzWH3iByR5nFkL6y
Ce8An0a888KWpQzbEqsk0MMl/QbMBSy0
=YjIv
-----END PGP SIGNATURE-----
