Introduction: Convert a Box2D to a closed rectangular polygon Geometry. Equivalent to PostGIS box2d::geometry. Degenerate boxes return the appropriate lower-dimensional geometry:
| Box2D shape | Returned geometry |
|---|---|
| Both axes have non-zero extent | POLYGON (closed rectangle) |
One axis collapsed (e.g. xmin == xmax) |
LINESTRING along the non-collapsed axis |
Both axes collapsed (xmin == xmax && ymin == ymax) |
POINT |
Format: ST_GeomFromBox2D(box: Box2D)
Return type: Geometry
Since: v1.9.1
SQL Example
SELECT ST_AsText(ST_GeomFromBox2D(ST_MakeBox2D(ST_Point(0.0, 0.0), ST_Point(2.0, 4.0))))Output:
POLYGON ((0 0, 0 4, 2 4, 2 0, 0 0))
ST_GeomFromBox2D is also produced by the SQL cast CAST(box AS geometry) — see Type conversion.
Returns NULL on NULL input.