[GENERAL] How to calculate length of path data without diagonals?
Hi, i need to calculate some length of path without diagonal. Some examples: length((5,5),(6,6))) returns 1.41. I need 2: 5,5 to 5,6 + 5,6 to 6,6. Is that possible?
Re: [GENERAL] How to calculate length of path data without diagonals?
On 12/23/10 10:25 AM, Romain Billoir wrote: Hi, i need to calculate some length of path without diagonal. Some examples: length((5,5),(6,6))) returns 1.41. I need 2: 5,5 to 5,6 + 5,6 to 6,6. Is that possible? a path of just two points? something like abs(x1-x2) + abs(y1-y2). -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to calculate length of path data without diagonals?
On 12/23/2010 1:25 PM, Romain Billoir wrote: Hi, i need to calculate some length of path without diagonal. Some examples: length((5,5),(6,6))) returns 1.41. I need 2: 5,5 to 5,6 + 5,6 to 6,6. Is that possible? You could write a function to get the Manhattan distance between two points, it is the sum of the absolute values of subtracting each part of the coordinate. e.g. ABS(x2 - x1) + ABS(y2 - y1) -- Stephen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to calculate length of path data without diagonals?
On 2010-12-23, Romain Billoir billo...@gmail.com wrote: --0015175ccf48e6186a049817fc59 Content-Type: text/plain; charset=ISO-8859-1 Hi, i need to calculate some length of path without diagonal. Some examples: length((5,5),(6,6))) returns 1.41. I need 2: 5,5 to 5,6 + 5,6 to 6,6. Is that possible? It's called Manhattan distance look it up, the arithmentic is easy. -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general