Re: [sqlite] View column data type affinity?

2017-01-15 Thread Darko Volaric
Yes, by giving the column a type, that determines its affinity. On Sun, Jan 15, 2017 at 8:08 PM, Joe Seeley wrote: > Is there a way when creating a view to specify the data type affinity for > each column? > ___ > sqlite-users

Re: [sqlite] View column data type affinity?

2017-01-15 Thread Richard Hipp
On 1/15/17, Joe Seeley 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

[sqlite] View column data type affinity?

2017-01-15 Thread Joe Seeley
Is there a way when creating a view to specify the data type affinity for each column? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users