Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 51EE1798DD1 for ; Wed, 17 Mar 2010 06:18:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 43721-01 for ; Wed, 17 Mar 2010 09:18:24 +0000 (UTC) X-Greylist: delayed 00:09:59.414841 by SQLgrey-1.7.6 Received: from mail.scanlab.de (mail.scanlab.de [62.138.55.241]) by mail.postgresql.org (Postfix) with ESMTP id 836E77983A0 for ; Wed, 17 Mar 2010 06:18:28 -0300 (ADT) Received: from unknown (HELO Exchange-Server.scanlab-intern.de) ([172.16.20.15]) by mail.scanlab-intern.de with ESMTP; 17 Mar 2010 10:08:26 +0100 Received: from Exchange-Server.scanlab-intern.de ([127.0.0.1]) by Exchange-Server.scanlab-intern.de ([fe80::899b:4a53:8d4d:6c13%10]) with mapi; Wed, 17 Mar 2010 10:08:26 +0100 From: Andreas Gaab To: "pgsql-sql@postgresql.org" Date: Wed, 17 Mar 2010 10:08:25 +0100 Subject: select points of polygons Thread-Topic: select points of polygons Thread-Index: AcrFsWbNjNDJix4VTsCY7mdYfAqeHA== Message-ID: <48DA836F3865C54B8FBF424A3B775AF6FDE728EC@Exchange-Server.scanlab-intern.de> Accept-Language: de-DE Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: de-DE Content-Type: multipart/alternative; boundary="_000_48DA836F3865C54B8FBF424A3B775AF6FDE728ECExchangeServers_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.23 tagged_above=-10 required=5 tests=AWL=-0.232, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/123 X-Sequence-Number: 33830 --_000_48DA836F3865C54B8FBF424A3B775AF6FDE728ECExchangeServers_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there, I have polygons with 5 points (left, center, right, top, bottom) Now I would like to select an individual point out of the polygon. Are ther= e any functions to provide this in an readable manner other than: e.g. SELECT replace(split_part(p::text,',(',1),'((','(')::point as point FR= OM ( SELECT '((0.001329116037,0.007391900417),(0.001371765621,0.1608393682),(0.1= 502391498,0.00733744679),(0.001500387404,-0.1468751078),(-0.1472653422,0.00= 7425591447))'::polygon as p) as poly =E8 (0.001329116037,0.007391900417) Thanks Andreas ___________________________________________________________________________ SCANLAB AG Dr. Andreas Simon Gaab Entwicklung * R & D Siemensstr. 2a * 82178 Puchheim * Germany Tel. +49 (89) 800 746-513 * Fax +49 (89) 800 746-199 mailto:a.gaab@scanlab.de * www.scanlab.de Amtsgericht M=FCnchen: HRB 124707 * USt-IdNr.: DE 129 456 351 Vorstand: Georg Hofner (Sprecher), Christian Huttenloher, Norbert Petschik Aufsichtsrat (Vorsitz): Dr. Hans J. Langer ___________________________________________________________________________ --_000_48DA836F3865C54B8FBF424A3B775AF6FDE728ECExchangeServers_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi there,

 

 

I have polygons with 5 points (left, center, right, top, bottom)

 

Now I would like to select an individual point out of the polygon. Are there an= y functions to provide this in an readable manner other than:

 

e.g. SELECT replace(split_part(p::text,',(',1),'((','(')::point as point FROM ( =

SELECT '((0.001329116037,0.007391900417),(0.001371765621,0.1608393682),(0.15023914= 98,0.00733744679),(0.001500387404,-0.1468751078),(-0.1472653422,0.007425591= 447))'::polygon as p) as poly

 

=E8 =  

 

Thanks

Andreas

 

 

_____________________= ______________________________________________________

 

SCANLAB AG<= /o:p>

Dr. Andreas = ;Simon Gaab

Entwicklung • R & D

 

Siemensstr. 2a &= #8226; 82178 Puchheim • Germany

Tel. +49 (8= 9) 800 746-513 • Fax +49 (89) 800 746-199

mailto:a.gaab@scanlab.de • www.scanlab.de

 

Amtsgericht M=FC= nchen: HRB 124707 • USt-IdNr.: DE 129 456 351=

Vorstand: Georg = Hofner (Sprecher), Christian Huttenloher, Norbert Petschik

Aufsichtsrat (Vo= rsitz): Dr. Hans J. Langer

_____________________= ______________________________________________________

 

--_000_48DA836F3865C54B8FBF424A3B775AF6FDE728ECExchangeServers_--