Re: How to calculate length of path data without diagonals? - Mailing list pgsql-general

From Stephen Cook
Subject Re: How to calculate length of path data without diagonals?
Date
Msg-id 4D13E93E.9040903@gmail.com
Whole thread Raw
In response to How to calculate length of path data without diagonals?  (Romain Billoir <billoirr@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Data backup to local duplicate without resetting permissions
Next
From: Jasen Betts
Date:
Subject: Re: Understanding Schema's