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