On 6/5/08, BareFeet <[EMAIL PROTECTED]> wrote: > > 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; > > > I was going to suggest using "^ 0.5" for square root, but now I see > that SQLite doesn't even support the "^" power of operator. Surely > this is a fundamental requirement of any syntax that supports basic > maths like addition, multiplication etc. > > Can/will the power operator be added to SQLite?
http://sqlite.org/contrib/download/extension-functions.c?get=22 > > Thanks, > Tom > > BareFeet > -- > Comparison of SQLite GUI tools for Mac OS X: > http://www.tandb.com.au/sqlite/compare/?ml > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users