[EMAIL PROTECTED] (Sebastian Albrecht) writes:
> how can I get single xy-points from a polygon like for example:
[ looks through pg_proc... ] Hmm, this seems to be an oversight
in the polygon datatype. I don't think it'd be real practical
to support an array-subscript-like notation, but certainl
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
