I understand the type can differ between rows, but that's also the case for a regular table, and https://www.sqlite.org/datatype3.html#affinity_of_expressions says
<< An expression of the form "CAST(expr AS type)" has an affinity that is the same as a column with a declared type of "type". >> so the sql engine already has to keep track of the affinity specified through "cast()" if I understood the above correctly On Sun, Apr 1, 2018 at 3:19 PM, Simon Slavin <slav...@bigfraud.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users