2009/8/23 P Kishor <punk.k...@gmail.com>: > If a line is expressed by (y = ax + c), you need to find all x,y that > will satisfy that equation. So, > > SELECT x, y, z > FROM terrain > WHERE a*x - y + c = 0
General equation of line is a*x + b*y + c = 0. If you delete parameter "b", you will have a problem with some pair of points - e.g. [0,0],[0,1]. Better way to save unit squares to file is a simple 2D matrix. No database. Fast and easy for samples with fixed steps of coordinates. You can load entire matrix into memory. -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
