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