Am 26.10.22 um 19:35 schrieb Mike Chinander:
I think it would be nice to have these math functions generally
available in queries, but I would like to point out that in your
example code, the angle you are taking the cosine of is a constant
rather than a value retrieved from the DB.
Uhm... yeah ;)
Maybe I should have used the well-known value "42" to make it more
obvious that this query was merely meant for "illustrative purposes" ;)
It is not my "real-world query", to be clear.
P.S. But indeed, I used this query to quickly test the existence of
"math functions" via "DB Browser for SQLite". The used "hard-coded"
coordinates are *very* roughly where I live ;)
Interest mailing list