> > The documentation refers to the column affinities TEXT, NUMERIC, > > INTEGER, REAL, and NONE, but NONE is not identified as a column > > affinity by the SQL parser, which treats it as NUMERIC. > > Column affinity is not part of the syntax - declared type is. The > affinity is inferred from the type. Column affinity is a semantic, > rather than a syntactic, concept, so it is meaningless to state whether > or not a parser identifies one.
Thanks for the reply. I really appreciate your fast and frequent feedback, though sometimes your obsession for correctness gets in the way of a simple answer. I think it's fine to gently nudge people to ask well-formed questions, but my question was quite clear despite the semantic/syntactic mismatch. Nevertheless thank you for making me a better person. Seriously. RW Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
