How to calculate length of path data without diagonals?

From: Romain Billoir <billoirr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to calculate length of path data without diagonals?
Date: 2010-12-23 18:25:01
Message-ID: AANLkTikJ2UUT9cg6i=GZvOo4QYYO3NdVPEk2taU1r1bP@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-12-23 18:28:43 Re: How to calculate length of path data without diagonals?
Previous Message Reto Schöning 2010-12-23 16:57:13 Re: "could not accept SSPI security context"