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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
