Re: No feedback for executing a mathematical expression
"Keith Medcalf" <[email protected]> Tue, 10 Mar 2020 01:57:57 -0600
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Organization | This Side Up |
| Message-ID | <[email protected]> |
On Tuesday, 10 March, 2020 01:22, Octopus ZHANG <[email protected]> wrote: >I try to run a simple math expression, but SQLite gives no feedback : >sqlite> select 99-(55/(30/57)); >Should I expect it to return nothing? It is returning something. It is returning NULL. sqlite> .nullvalue <NULL> sqlite> select 99-(55/(30/57)); <NULL> sqlite> 99 - (55 / (30 / 57)) 30 / 57 -> 0 55 / 0 -> NULL 99 - NULL -> NULL If you want the result of 30/57 to be a floating point number (ie, not zero), you need to have one of those numbers be floating point, after which each successive operation will be carried out in floating point rather than integer arithmetic. 30. / 57 == 30 / 57. == 30. / 57. -> 0.526315789473684 55 / 0.526315789473684 -> 104.5 99 - 104.5 -> -5.5 -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users