Re: How to calculate length of path data without diagonals?
От
Stephen Cook
Тема
Re: How to calculate length of path data without diagonals?
Дата
Msg-id
4D13E93E.9040903@gmail.com
Ответ на
How to calculate length of path data without diagonals? (Romain Billoir)
Список
Дерево обсуждения
Re: How to calculate length of path data without diagonals? Jasen Betts <jasen@xnet.co.nz>
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 по дате отправления
От: Adrian Klaver
Дата: