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

[R Smith]

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users