From A.Gaab@scanlab.de Wed Mar 17 09:18:40 2010 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_-- From tgl@sss.pgh.pa.us Wed Mar 17 14:21:44 2010 Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id F30D9632E5A for ; Wed, 17 Mar 2010 11:21:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23273-09 for ; Wed, 17 Mar 2010 14:21:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 629C5634B43 for ; Wed, 17 Mar 2010 11:21:34 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o2HELWI9027816; Wed, 17 Mar 2010 10:21:32 -0400 (EDT) To: Andreas Gaab cc: "pgsql-sql@postgresql.org" Subject: Re: select points of polygons In-reply-to: <48DA836F3865C54B8FBF424A3B775AF6FDE728EC@Exchange-Server.scanlab-intern.de> References: <48DA836F3865C54B8FBF424A3B775AF6FDE728EC@Exchange-Server.scanlab-intern.de> Comments: In-reply-to Andreas Gaab message dated "Wed, 17 Mar 2010 10:08:25 +0100" Date: Wed, 17 Mar 2010 10:21:32 -0400 Message-ID: <27815.1268835692@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/135 X-Sequence-Number: 33842 Andreas Gaab writes: > 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 any functions to provide this Doesn't look like it :-(. Seems like rather an oversight. regards, tom lane