Re: Is it ever legal (should be supported) to issue a non select in selectall_arrayref?

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