Skip to main content
Tests whether geography A fully contains geography B using S2 spherical boolean operations. Returns true if every point of B is inside or on the boundary of A. ST_Contains returning true ST_Contains returning false

​
Signatures

ST_Contains (A: Geography, B: Geography)

​
Parameters

​
A
Geography
required
The containing geography.
​
B
Geography
required
The geography tested for containment within A.

​
Return type

true if A fully contains B.

​
Example

SELECT ST_Contains(
  ST_GeogFromWKT('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))'),
  ST_GeogFromWKT('POINT (0.5 0.5)')
);

true