There is also a problem with the documentation on csv.c
Example from the source comments:
CREATE VIRTUAL TABLE temp.csv2 USING csv(
filename = "../http.log",
schema = "CREATE TABLE x(date,ipaddr,url,referrer,userAgent)"
);
It should be noted that the schema= parameter allows one to specify names,
NOT types. Everything is set to a datatype of TEXT. Any datatype
declarations are ignored.
so with
"CREATE VIRTUAL TABLE temp.csv2 USING csv(
filename = "../http.log",
schema = "CREATE TABLE x(anbr INTEGER ,ipaddr,url,referrer,userAgent)"
);
typeof (anbr) is "text"
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
