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
Ответ на
Список
Дерево обсуждения
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
Дата:
От: Jasen Betts
Дата:
Сообщение: Re: Understanding Schema's
FAQ