BUG #2240: length() with geometric types

Поиск
Список
Период
Сортировка
От Andreas Erber
Тема BUG #2240: length() with geometric types
Дата
Msg-id 20060206144139.B5F65F0AC7@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2240: length() with geometric types  (James William Pye <pgsql@jwp.name>)
Список pgsql-bugs
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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Márcio A. Sepp
Дата:
Сообщение: Problems with createlang - windows
Следующее
От: "Matthew Bellew"
Дата:
Сообщение: BUG #2242: Inconsistent casting in query with literal vs query with parameter