On Sep 17, 2011, at 10:11 AM, Igor Tandetnik wrote: > Jim Michaels > <jimm-VsnNql4zhRrV7NJZ79vff+jYdJvx94icpqFO/160wmvqt0dzr+a...@public.gmane.org> > wrote: >> INSERT is supposed to handle multiple rows for VALUES. > > Supposed by whom? What is the basis for this claim?
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. -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
