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.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
