From 69dedece9017027cefddb8bf2d0dcd1d308ea67a Mon Sep 17 00:00:00 2001 From: Paul Ramsey Date: Wed, 10 Jul 2019 21:34:40 +0000 Subject: [PATCH] Add example using optional bounds git-svn-id: http://svn.osgeo.org/postgis/trunk@17588 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_constructor.xml | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/doc/reference_constructor.xml b/doc/reference_constructor.xml index 91c5fcf6e..87ef1ead9 100644 --- a/doc/reference_constructor.xml +++ b/doc/reference_constructor.xml @@ -788,9 +788,15 @@ SRID=4326;POLYGON((75 29 1, 77 29 2, 77 29 3, 75 29 1)) Example: Building a tile envelope SELECT ST_AsText( ST_TileEnvelope(2, 1, 1) ); -st_astext + st_astext ------------------------------ -POLYGON((-10018754.1713945 0,-10018754.1713945 10018754.1713945,0 10018754.1713945,0 0,-10018754.1713945 0)) + POLYGON((-10018754.1713945 0,-10018754.1713945 10018754.1713945,0 10018754.1713945,0 0,-10018754.1713945 0)) + +SELECT ST_AsText( ST_TileEnvelope(3, 1, 1, ST_MakeEnvelope(-180, -90, 180, 90, 4326) ) ); + + st_astext +------------------------------------------------------ + POLYGON((-135 45,-135 67.5,-90 67.5,-90 45,-135 45)) -- 2.40.0