Skip site navigation (1) Skip section navigation (2)

Breaking Path/Polygon Data into Pieces

From: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
To: pgsql-general(at)postgresql(dot)org
Subject: Breaking Path/Polygon Data into Pieces
Date: 2006-02-27 18:41:52
Message-ID: 20060227184152.GA1194@alamut (view raw or flat)
Thread:
Lists: 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.

Responses

pgsql-general by date

Next:From: Bruno Wolff IIIDate: 2006-02-27 18:54:22
Subject: Re: Wish: remove ancient constructs from Postgres
Previous:From: CGDate: 2006-02-27 18:27:20
Subject: Re: ltree + gist index performance degrades significantly over a night

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group