On Sep 17, 2011, at 10:33 AM, Simon Slavin wrote: > > On 17 Sep 2011, at 4:29pm, Mr. Puneet Kishor wrote: > >> The multiline INSERT capability may not be a SQL standard, but it is not >> only highly convenient, it is also supported by Pg, the ostensible role >> model and inspiration for SQLite. Not that I particularly care either way >> because I almost always use Perl to deal with Pg and SQLite, but it >> would/might be nice to have for some. Perhaps those folks should continue to >> ask Richard nicely instead of seeming to "demand" it on the basis of some >> political claim. > > How would you support multiple INSERTs with binding ?
I wouldn't. Multiple INSERT statement seems to be better suited for large scale dump/restore, or even for manual entry, but without binding. Essentially, if I had my druthers, I would support whatever Pg supports and be done with it. For most part SQLite seems to follow "good for Pg good for the gander" philosophy. > Given a statement like > >> INSERT INTO table(digit,dialpadstr) VALUES >> (2,'abc'),(3,'def'),(4,'ghi'),(5,'jkl'),(6,'mno'),(7,'pqrs'),(8,'tuv'),(9,'wxyz'); > > would you expect 16 binding values ? > > Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users