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

Reply via email to