Getting points from polygon

From: albrechtt(at)inseal(dot)de (Sebastian Albrecht)
To: pgsql-sql(at)postgresql(dot)org
Subject: Getting points from polygon
Date: 2004-08-12 16:59:23
Message-ID: cf4494fc.0408120859.364d267c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

how can I get single xy-points from a polygon like for example:

CREATE TABLE "public"."country"
(
"country_id" INTEGER NOT NULL,
"geo" polygon NOT NULL
)

SELECT geo.x, geo.y FROM country WHERE geo.x=5

or

SELECT geo[24th point].x FROM country

...

Thanks in advance and best regards,
Sebastian

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message --CELKO-- 2004-08-12 19:45:01 Re: Suggestions on storing re-occurring calendar events
Previous Message Edmund Bacon 2004-08-12 16:58:08 Re: [SQL] how to cast localtimestamp to bigint???