Breaking Path/Polygon Data into Pieces

Поиск
Список
Период
Сортировка
От Volkan YAZICI
Тема Breaking Path/Polygon Data into Pieces
Дата
Msg-id 20060227184152.GA1194@alamut
обсуждение исходный текст
Ответы Re: Breaking Path/Polygon Data into Pieces  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
Hi,

2 weeks ago, a user in -tr-genel asked for a function to break
path/polygon type data into pieces. He also told that, it creates a
bottleneck in the network traffic when they try to receive rows with
polygon data of thousands of nodes, while it's enough for them to
have polygons partially.

AFAIK, there doesn't exist such functions in PostgreSQL. (Please
correct me if I'm wrong.) For this purpose, I've coded two simple
C procedures:

  polygon part(polygon, offset, limit)
  path    part(path, offset, limit)

I thought it would be nice to see these functions in PostgreSQL and
wanted to ask for other users (and developers) ideas.


Regards.

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Wish: remove ancient constructs from Postgres
Следующее
От: Bernhard Weisshuhn
Дата:
Сообщение: Re: ltree + gist index performance degrades significantly over a night