On 2017/09/06 11:58 PM, R Smith wrote:
Your CHECK constraint should really find that the value is acceptable
when it is either a REAL, OR an INT, because both those types of data
satisfies your requirement.
To be specific, this should work for you:
CREATE TABLE weights(
float REAL,
CONSTRAINT float CHECK(TYPEOF(float) IN ("real","int"))
);
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
