Hello. For a pity, I do not have an exact answer on how to do your task in a best way with MySQL. Searching in the archives gave me these links: http://lists.mysql.com/mysql/185851 http://lists.mysql.com/mysql/185846
Perhaps, you will need the help of stored routines or UDFs: http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html Jose Antonio wrote: > MySQL offers Spacial Extensions to operate with points in a 2 dimensional > space. > > For a project I'm working on, I need to work with points in an N dimensional > space and measure the distance among them. Is there a clever do to solve the > following problem?: > > Let's say I have 4 3D point (X,Y,Z): > > (0,0,0), (1,1,1), (4,4,2), (-2,30,18) > > And for a new point (3, -1, 1.5), I need to know which of my other points > are closer and what the distance is. > > Any clues? > > Thank you in advance, > Jose. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
