You can do your own custom functions using the C extentions. You should buy the book. "The Definitive Guide SQLite" On Thu, Jun 5, 2008 at 6:55 PM, Scott Baker <[EMAIL PROTECTED]> wrote:
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users