On Sep 17, 2011, at 8:06 PM, Simon Slavin wrote: > <insert columns and source> ::= <from subquery> | <from constructor> | > <from default> > > ? Which one, and where is the expansion that allows for multiple sets of > brackets after "VALUES" ?
If I'm reading this correctly, the constructor one. Step by step: (1) insert statement http://savage.net.au/SQL/sql-99.bnf.html#insert%20statement (2) insert columns and source http://savage.net.au/SQL/sql-99.bnf.html#insert%20columns%20and%20source (3) from constructor http://savage.net.au/SQL/sql-99.bnf.html#from%20constructor (4) contextually typed table value constructor http://savage.net.au/SQL/sql-99.bnf.html#contextually%20typed%20table%20value%20constructor (5) contextually typed row value expression list http://savage.net.au/SQL/sql-99.bnf.html#contextually%20typed%20row%20value%20expression%20list <contextually typed row value expression list> ::= <contextually typed row value expression> [ { <comma> <contextually typed row value expression> }... ] (6) contextually typed row value constructor <contextually typed row value constructor element> | [ ROW ] <left paren> <contextually typed row value constructor element list> <right paren> http://savage.net.au/SQL/sql-99.bnf.html#contextually%20typed%20row%20value%20constructor Phew. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
