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.
