Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tnzbs-004YaH-Td for pgsql-docs@arkaria.postgresql.org; Fri, 28 Feb 2025 12:36:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tnzbu-00551G-03 for pgsql-docs@arkaria.postgresql.org; Fri, 28 Feb 2025 12:36:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tnzbt-005500-An for pgsql-docs@lists.postgresql.org; Fri, 28 Feb 2025 12:36:56 +0000 Received: from fout-a6-smtp.messagingengine.com ([103.168.172.149]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tnzbl-000AeA-1q for pgsql-docs@lists.postgresql.org; Fri, 28 Feb 2025 12:36:55 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id D8A35138278C; Fri, 28 Feb 2025 07:36:48 -0500 (EST) Received: from phl-imap-09 ([10.202.2.99]) by phl-compute-05.internal (MEProxy); Fri, 28 Feb 2025 07:36:48 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1740746208; x=1740832608; bh=CVOZrqY1C/ p5JLXbwk3RxVOONCm1nDvPhEIOcZmZd14=; b=u3Rn7H87TVmNBjtGJFmwWUyIdX 26irlOl8OlfcOEOtSBWbb65iE7/BAGfUpPMheds2s3wFyz8JAh/nNUc7gcGhXYAR fqJd4weyZR4jMDs56+YWh/ZG6s8ZhwUuRQWmbt/9AUGXal95c5vkLTFvY2DzqKZx DJbkKJhglSPqK4maWLKYpOHnDZ68jnWa7YHv7kok+LeYo8TvFoPKwTKEMrw7j01A N+Pw8ybVQSAybbJ4D8j3jOQaO1tLWzAGOYJroaxm9tGKuYHyXMB/+ppGxbolB9Pv QZpKgjl1jDadfFcDztowgoA8VFflbmFX0/yfT039ldmwx0XRI7cAXZtm2ptw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1740746208; x=1740832608; bh=CVOZrqY1C/p5JLXbwk3RxVOONCm1nDvPhEI OcZmZd14=; b=hS3bJDqaT/UmCX7L6dHhjkrigtYNdBnFRRVLYg1ih7I9JeOTUuc eV+fiZ18SSGpc+iFr12wqtqHhqtj43zncT/UbWSXw9sbq+UydX0aBcGm8IfcAx9K pViRJupyszEOE9g9YWhnYaoi2cLBUtT0TiUwHwVNUBDzhgZ2m100RJZWoWHQX/2d lNbuiccOxDj8Z/Pw96Qmi2OX6qF+gKlJW7UzO5RDK/FaYf/vfwPJBpSWS2U1tKaW Ko/C4nyMOSvKoTybXhIkd1sz7qNy9iExk7rdkNqqebXDv+XDo21CHzEGKpMIvct9 1lGLJaxgDZcmtYrNHTqRPAzmZ1JmvZvhIgQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdeltdegudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecunecujfgurhepofggff fhvffkjghfufgtsegrtderreertddtnecuhfhrohhmpedfgfhulhgvrhcuvfgrvhgvihhr rgdfuceovghulhgvrhesvghulhgvrhhtohdrtghomheqnecuggftrfgrthhtvghrnhepke ejvdehgfejkeeuhefggeeukeejgffgtdeuteffleeugfehiedtgeffhfegueehnecuffho mhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghdpvghnthgvrhhprhhishgvuggsrdgtoh hmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepvghu lhgvrhesvghulhgvrhhtohdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmh htphhouhhtpdhrtghpthhtohepsghlvghsshihgeehiegsthhhohhmrghssehgmhgrihhl rdgtohhmpdhrtghpthhtohepphhgshhqlhdqughotghssehlihhsthhsrdhpohhsthhgrh gvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 7D773780068; Fri, 28 Feb 2025 07:36:48 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 Date: Fri, 28 Feb 2025 09:36:28 -0300 From: "Euler Taveira" To: blessy456bthomas@gmail.com, pgsql-docs@lists.postgresql.org Message-Id: <0051060c-d934-4b99-97f2-19452fe1f933@app.fastmail.com> In-Reply-To: <173892503829.1070.3817164543510055729@wrigleys.postgresql.org> References: <173892503829.1070.3817164543510055729@wrigleys.postgresql.org> Subject: Re: Regarding explanation to store and retrieve postgres geometric features Content-Type: multipart/alternative; boundary=c6a29541cfa845a7acdeb1cc4f6599f0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --c6a29541cfa845a7acdeb1cc4f6599f0 Content-Type: text/plain Content-Transfer-Encoding: 7bit On Fri, Feb 7, 2025, at 7:43 AM, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/17/datatype-geometric.html > Description: > > I have found section for 8.8. Geometric Types > 8.8.1. Points > 8.8.2. Lines > 8.8.3. Line Segments > 8.8.4. Boxes > 8.8.5. Paths > 8.8.6. Polygons > 8.8.7. Circles but dont find how to use it and test it. can you add a > detailed explanation or provide some references. > This page says A rich set of functions and operators is available to perform various geometric operations such as scaling, translation, rotation, and determining intersections. They are explained in Section 9.11. Hence, check the referred section. -- Euler Taveira EDB https://www.enterprisedb.com/ --c6a29541cfa845a7acdeb1cc4f6599f0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Fri, Feb 7, = 2025, at 7:43 AM, PG Doc comments form wrote:
Description:

I have found section for 8.8. Geometric Types 
8.8.1. Points
8.8.2. Lines
8.8.3= . Line Segments
8.8.4. Boxes
8.8.5. Paths
8.8.6. Polygons
8.8.7. Circles but dont find h= ow to use it and test it. can you add a
detailed explanati= on or provide some references.


This page says

A rich set o= f functions and operators is available to perform various geometric
<= /div>
operations such as scaling, translation, rotation, and determi= ning
intersections. = They are explained in Section 9.11.

Hence, = check the referred section.


--
Euler Taveira
EDB  = ; https://www.enterprisedb.com= /

--c6a29541cfa845a7acdeb1cc4f6599f0--