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.

Cheers, Oliver

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

Reply via email to