Paul Boddie wrote: > To be fair, that text originates in section 12.3, referring to input > parameters to procedures. Meanwhile, the following text (subclause > 13.8, "<insert statement>") appears to be more pertinent: > > "If the data type of the target identified by the i-th <column name> is > an exact numeric type, then the data type of the i-th item of the > <insert statement> shall be an exact numeric type."
And SQLite behaves as expected if you provide a numeric value to a numeric column, right? In other words, it complies to that clause. Does the spec state how the database engine should behave if the client breaks the requirements for insert? I guess that this is implementation dependent. -- http://mail.python.org/mailman/listinfo/python-list
