Re: Breaking Path/Polygon Data into Pieces - Mailing list pgsql-general

From Volkan YAZICI
Subject Re: Breaking Path/Polygon Data into Pieces
Date
Msg-id 20060228191647.GA159@alamut
Whole thread Raw
In response to Re: Breaking Path/Polygon Data into Pieces  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Feb 27 03:10, Michael Fuhr wrote:
> PostGIS has geometry accessors that might work.  You'd need to be
> using PostGIS geometry types instead of the PostgreSQL types.
>
> http://postgis.refractions.net/docs/ch06.html
>
> Are the following examples anything like what the user in tr-general
> was looking for?

Yes. As I understand from your examples, they're quite efficient for
related purposes I mentioned. But wouldn't it worth adding a simple
part() function for this? Because, with this feature, people won't need
to use another project for such a basic operation on path and polygon
types which are supported by PostgreSQL by default.


Regards.

pgsql-general by date:

Previous
From: Pelle Johansson
Date:
Subject: PQisBusy returns true but no more data is received.
Next
From: Tom Lane
Date:
Subject: Re: PQisBusy returns true but no more data is received.