[PostGIS] #6075: Extend ST_GetFaceGeometry with a optional srid parameter for geom

[PostGIS]

#6075: Extend ST_GetFaceGeometry with a optional srid parameter for geom
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  strk
      Type:  enhancement        |     Status:  new
  Priority:  medium             |  Milestone:  PostGIS 3.6.3
 Component:  topology           |    Version:  3.6.x
Resolution:                     |   Keywords:
--------------------------------+---------------------------
Comment (by strk):

 Transforming individual edges or the final geometry won't make any
 difference as transformation happens on a vertex-by-vertex basis, no
 matter how they are connected.

 To prove this, I created a table with the inputs in #6071 and used this
 query:
 {{{
 select i, st_equals(
   ST_ExteriorRing(st_transform(g, 4258)), -- transform whole geom
   ST_MakeLine(st_transform(d.geom, 4258)) -- transform each vertex and
 reconstruct
 )
 from t6071_inp,
 lateral st_dumppoints(g) d
 group by i, g;
  i | st_equals
 ---+-----------
  2 | t
  1 | t
 (2 rows)
 }}}

 The t6071_inp table was created with the geometries in 3035 SRID.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6075#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.