The following bug has been logged online:
Bug reference: 2240
Logged by: Andreas Erber
Email address: post@andreas-erber.net
PostgreSQL version: 8.0.2
Operating system: Windows XP
Description: length() with geometric types
Details:
Hi,
I discovered some strange behaviour:
The length() function returns different results depending on the geometric
data type used as argument.
length(lseg) produces the correct result, i.e. length(lseg('(0,0),(2,0)')) =
2
length(path) always produces the double result (independently from the
length of the path), i.e.
length(path('(0,0),(2,0)')) = 4
length(path('(0,0),(2,0),(4,0),(6,0),(8,0)')) = 16
Is it supposed to be that way? If yes, why?
CU
ae