Re: [sqlite] Should the INTEGER not be cast to a REAL

[R Smith]

On 2017/09/07 12:35 AM, Cecil Westerhof wrote:

​It does not, but this does:
CREATE TABLE weights(
     float  REAL,

     CONSTRAINT float CHECK(TYPEOF(float) IN ("real","integer"))
);

Instead of "int" you need "integer".

yes of course... My bad, sorry, but at least you've solved it :)
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users