[PostGIS] #5799: ST_TileEnvelope with margin is not clipped fully to WM extent

[PostGIS]

#5799: ST_TileEnvelope with margin is not clipped fully to WM extent
----------------------+---------------------------
  Reporter:  mdavis   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.5.1
 Component:  postgis  |    Version:  3.5.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by mdavis):

 A workaround is to clip the generated envelope to the WM bounds:
 {{{
 -- clip tile envelope to WebMercator bounds
 ST_Intersection(
      ST_MakeEnvelope(-20037508.342789, -20037508.342789,20037508.342789,
 20037508.342789, 3857),
      ST_TileEnvelope(z, x, y, margin => 0.125) )

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5799#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.