ST_MakeEnvelope

Construct a Polygon from MinX, MinY, MaxX, MaxY, and an optional SRID.

Signatures

ST_MakeEnvelope(MinX: Double, MinY: Double, MaxX: Double, MaxY: Double)

ST_MakeEnvelope(MinX: Double, MinY: Double, MaxX: Double, MaxY: Double, srid: Integer)

Double

required

The min x value.

Double

required

The min y value.

Double

required

The max x value.

Double

required

The max y value.

Integer

Spatial Reference Identifier.

The resulting geometry.

SELECT ST_MakeEnvelope(1.234, 2.234, 3.345, 3.345, 4236)

POLYGON ((1.234 2.234, 1.234 3.345, 3.345 3.345, 3.345 2.234, 1.234 2.234))

⌘I