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"))
> );


​But it does not.

The strange thing is: when I remove the constraint and do:
INSERT INTO testing
(float)
VALUES
(0)

The insert is successful of-course.
When I then execute:
SELECT float, TYPEOF(float)
FROM testing

I get:
"0.0"    "real"


Maybe this is correct, but it is certainly confusing.

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to