On 1/15/17, Joe Seeley <joiey.see...@gmail.com> wrote: > Is there a way when creating a view to specify the data type affinity for > each column?
Make each in the SELECT that implements the view be of the form: CAST(column AS TYPE) Type affinity for views and subqueries is messed up. It has been for a long time. This has just come to our attention recently and we are working on it. Hopefully things will be better in 3.17.0. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users