| From: | Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Breaking Path/Polygon Data into Pieces |
| Date: | 2006-02-28 19:16:47 |
| Message-ID: | 20060228191647.GA159@alamut |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-02-28 19:35:26 | Re: PQisBusy returns true but no more data is received. |
| Previous Message | Pelle Johansson | 2006-02-28 18:52:32 | PQisBusy returns true but no more data is received. |