On 1 Apr 2018, at 8:19am, Eric Grange <egra...@glscene.org> wrote: > The decl_type allows to differentiate a datetime, or a "wide" text from a > single char text column
The reason descl_type does not work on expressions is the reason I illustrated in my previous post: the expression can have a different type for different rows of the result and therefore has no affinity throughout the entire set of results. You could, perhaps, check the types of the first row of results, and assume that all rows will have the same types. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
