Built-In Function and Operator Reference Name Description Introduced Deprecated ST_GeomFromText() , ST_GeometryFromText() Return geometry from WKT ST_GeomFromWKB() , ST_GeometryFromWKB() Return geometry from WKB ST_HausdorffDistance() The discrete Hausdorff distance of one geometry from another 8.0.23 ST_InteriorRingN() Return N-th interior ring of Polygon ST_Intersection() Return point set intersection of two geometries ST_Intersects() Whether one geometry intersects another ST_IsClosed() Whether a geometry is closed and simple ST_IsEmpty() Whether a geometry is empty ST_IsSimple() Whether a geometry is simple ST_IsValid() Whether a geometry is valid ST_LatFromGeoHash() Return latitude from geohash value ST_Latitude() Return latitude of Point 8.0.12 ST_Length() Return length of LineString ST_LineFromText() , ST_LineStringFromText() Construct LineString from WKT ST_LineFromWKB() , ST_LineStringFromWKB() Construct LineString from WKB ST_LineInterpolatePoint() The point a given percentage along a LineString 8.0.24 ST_LineInterpolatePoints() The points a given percentage along a LineString 8.0.24 ST_LongFromGeoHash() Return longitude from geohash value ST_Longitude() Return longitude of Point 8.0.12 ST_MakeEnvelope() Rectangle around two points ST_MLineFromText() , ST_MultiLineStringFromText() Construct MultiLineString from WKT 2111