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
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
2 matches
Mail list logo