On 10/6/17, R Smith <rsm...@rsweb.co.za> wrote:
> I'd also like to see a Unary NOT operator, such that you can say: a = !b
In SQL and SQLite that would be: a = NOT b
> But, I guess that's only feasible in a strongly typed language.
(1) I object to the characterization of SQLite not being "strongly
typed". SQLite is "flexibly typed" in the sense that it provides the
application with a lot of flexibility with regard to what datatypes
are allowed to be stored in a particular column or participate in an
operation. Other SQL database engines are "rigidly typed". Those
other SQL implementations are much more judgmental about what you can
and cannot do with your data.
(2) Why is rigid typing required in order to implement boolean negation?
D. Richard Hipp
sqlite-users mailing list