2017-09-07 0:05 GMT+02:00 R Smith <rsm...@rsweb.co.za>:
> 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"))
It does not, but this does:
CREATE TABLE weights(
CONSTRAINT float CHECK(TYPEOF(float) IN ("real","integer"))
Instead of "int" you need "integer".
sqlite-users mailing list