On 17 Sep 2011, at 6:08pm, Petite Abeille wrote: > On Sep 17, 2011, at 6:04 PM, Simon Slavin wrote: > >> Can you find the syntax that allows > > These ANSI specifications are notoriously difficult to pinpoint :)
Not really, they just cost money. For instance: <http://webstore.ansi.org/RecordDetail.aspx?sku=INCITS%2fISO%2fIEC+9075-1-2008> That's part 1 and costs US$30. For a good grasp of SQL you need most of the first 11 parts. Part 11, for instance costs US$321.00. Consequently nobody buys them. And consequently nobody cares what they say. > Pretty consistent syntax across vendors, and not totally outlandish 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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users