On Tue, 14 Jul 2015 10:22:02 -0700, Hayden Livingston
<halivingston at gmail.com> wrote:
> Wow, this is the killer feature no-one told me about.
> I can get rid of types? How does this work under-the-hood?
>
> SELECT * FROM TABLE WHERE FooColumn > 50
>
> And I've stored "Something" in that column in some row.
> What's the behavior?
That's easy to test by yourself.
By the way, you can enforce datatype to some extend with
constraints:
CREATE TABLE T1 (
id INTEGER PRIMARY KEY NOT NULL
, anint INTEGER
CONSTRAINT int_anint CHECK (typeof(anint) == 'integer')
);
INSERT INTO T1 (anint) VALUES (1);
INSERT INTO T1 (anint) VALUES ('two');
> I don't want to take up your time, so if there's a document I can read
> about it'd be great.
https://sqlite.org/datatype3.html
All docs:
https://sqlite.org/docs.html
--
Regards, Cordialement, Groet,
Kees Nuyt
