I have a database with coordinates in it. I'd like to calculate distance at 
the SQL level, but the equation for calculating distance requires square 
root and I'm not sure if I can do this with sqlite. Something like:

SELECT PlaceName, sqrt((PlaceX - 1)^2 - (PlaceY - 3)^2) AS DistFromHome 
FROM Table WHERE PlaceGroup = 3;

What mathematical functions can I do at the sqlite level? I'll preface this 
with, with stock SQLite (no added components) as it's on a shared web host.

-- 
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to