Returns the geometry with the element order reversed.
Syntax
geometry-expression.ST_Reverse()
Returns
ST_Geometry Returns the geometry with the element order reversed.
Examples
Example 1 –
The following example returns the result LineString (3 4, 1 2). It shows how the order of points in a linestring is reversed by ST_Reverse.
SELECT NEW ST_LineString( NEW ST_Point(1,2), NEW ST_Point(3,4) ).ST_Reverse()