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(
CONSTRAINT float CHECK(TYPEOF(float) IN ("real","int"))
sqlite-users mailing list