On 1/15/17, Joe Seeley <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
