ST_Reverse-PolarDB(PolarDB)-阿里云帮助中心

Returns a geometry object with the vertex order reversed.

Syntax

geometry ST_Reverse(geometry g1);

Parameters

Parameter	Description
`g1`	The geometry object whose vertices to reverse.

Description

Reverses the vertex order of any geometry object, including polyhedral surfaces.
Preserves z coordinates — 3D objects are fully supported.

Example

The following query reverses a LINESTRING and displays the original and reversed geometries side by side:

SELECT
  ST_AsText(geom)             AS original,
  ST_AsText(ST_Reverse(geom)) AS reversed
FROM (
  SELECT ST_GeomFromText('LINESTRING(2 1,1 1)') AS geom
) AS t;

Output:

     original      |     reversed
--------------------+--------------------
 LINESTRING(2 1,1 1) | LINESTRING(1 1,2 1)
(1 row)