[postgis-tickets] [PostGIS] #4641: ST_TileEnvelope default geometry precision

[PostGIS]

#4641: ST_TileEnvelope default geometry precision
--------------------------+---------------------------
  Reporter:  Algunenano   |      Owner:  pramsey
      Type:  enhancement  |     Status:  closed
  Priority:  medium       |  Milestone:  PostGIS 3.1.0
 Component:  postgis      |    Version:  master
Resolution:  fixed        |   Keywords:
--------------------------+---------------------------

Comment (by Algunenano):

 I'm not sure why updating the default value doesn't require dropping the
 old one, but it works:

 {{{
 # Select postgis_extensions_upgrade();
 NOTICE:  Updating extension postgis 3.1.0dev
 NOTICE:  Updating extension postgis_raster 3.1.0dev
 NOTICE:  Updating extension postgis_topology 3.1.0dev
 NOTICE:  Extension postgis_tiger_geocoder is not available or not
 packagable for some reason
                     postgis_extensions_upgrade
 -------------------------------------------------------------------
  Upgrade completed, run SELECT postgis_full_version(); for details
 (1 row)


 # \df *st_tileenvelope*
 List of
  functions
  Schema |      Name       | Result data type |
             Argument data types
 | T
 ype
 --------+-----------------+------------------+-------------------------------------------------------------------------------
 --------------------------------------------------------------------------------------------------------------------------+--
 ----
  public | st_tileenvelope | geometry         | zoom integer, x integer, y
 integer, bounds geometry DEFAULT '0102000020110F000
 00200000093107C45F81B73C193107C45F81B73C193107C45F81B734193107C45F81B7341'::geometry,
 margin double precision DEFAULT 0.0 | f
 unc

 # SELECT ST_AsText( ST_Transform(ST_TileEnvelope(0, 0, 0), 4326));
 st_astext
                                                          st_astext
 ---------------------------------------------------------------------------------------------------------------------------
  POLYGON((-180 -85.0511287798066,-180 85.0511287798066,180
 85.0511287798066,180 -85.0511287798066,-180 -85.0511287798066))
 (1 row)
 }}}


 So LGTM. Thanks for tackling this, Paul.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4641#comment:3>
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.