-----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 g...@turnstep.com 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-----