Getting points from polygon - Mailing list pgsql-sql

From albrechtt@inseal.de (Sebastian Albrecht)
Subject Getting points from polygon
Date
Msg-id cf4494fc.0408120859.364d267c@posting.google.com
Whole thread Raw
Responses Re: Getting points from polygon  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-sql by date:

Previous
From: "Arash Zaryoun"
Date:
Subject: Performance Problem With Postgresql!
Next
From: Pentilian
Date:
Subject: Re: Wierd Error on update