On Sep 17, 2011, at 1:06 PM, Simon Slavin wrote:
>
> On 17 Sep 2011, at 6:42pm, Petite Abeille wrote:
>
>> On Sep 17, 2011, at 7:33 PM, Simon Slavin wrote:
>>
>>> As was clear from my post, I was referring to SQL standards. What various
>>> implementation vendors choose to do is up to them. But the multi-spec
>>> syntax referred to in the OP is not in any SQL standard I've seen.
>>
>> In BNF Grammar for ISO/IEC 9075:1999 - Database Language SQL (SQL-99), under
>> contextually typed row value expression list:
>>
>> http://savage.net.au/SQL/sql-99.bnf.html#contextually%20typed%20row%20value%20expression%20list
>
> <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" ?
>
All this chattering among us doesn't really matter (other than for academic
purposes). All that matters is whether or not Richard and co. deem it worth
including as a capability in factory provided SQLite. While I can't attest to
it, there are probably instances where SQLite deviates from the so called
standard ("the problem with standards is there are plenty of them" and all
that). For me, if Pg does it, the SQLite could do it if those who make SQLite
could be convinced of its usefulness.
For me, I don't care either way. I am glad Pg has it because I am trying to
convert MySQL data to Pg. While I am failing to do so painlessly for the most
part, a few of the (simpler) tables convert fine because both MySQL and Pg
support multi-line INSERTs.
Puneet.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
