Re: Getting points from polygon

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: albrechtt(at)inseal(dot)de (Sebastian Albrecht)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Getting points from polygon
Date: 2004-08-15 19:43:18
Message-ID: 29107.1092598998@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

albrechtt(at)inseal(dot)de (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 certainly a
function like point(polygon, n) wouldn't be too hard to add.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Theo Galanakis 2004-08-15 23:46:41 CROSS-TAB query help? I have read it cant be done in one SQL, pro ve them wrong!
Previous Message Frank Finner 2004-08-15 19:17:49 Re: LIKE '%%' does not return NULL