P.S. Even if I do:
SELECT cast(dump+100 AS integer) FROM fstab;
the sqlite3_column_decltype() still does not return the integer type.
Would it be possible to modify this function or add a new one, to tell the
correct type at least if there is an explicit cast like this in given query?
If I do: SELECT cast("xxx" AS integer); it returns 0. So I hope that it is not
too immodest to expect that all values of such column will have the same type
(or be null).
Franta
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
