Name
ST_Point_Inside_Circle — Tests if a point is inside a circle defined by its center coordinates and radius.
Synopsis
boolean
ST_Point_Inside_Circle(bytea Point, double
Center_X, double
Center_Y, double
radius);
Description
Tests if a point is inside a circle defined by its center coordinates and radius, returns True if so. Input geometry must be a point.
Coordinate Dimensions
| 2D | 3D | M |
|---|---|---|
 | | |
Spatial Standards Support
| OGC SFS for SQL. 1.1 (1999) | OGC SFS for SQL. 1.1.0 (2005) | OGC SFS for SQL. 1.2.0 (2006) | SQL-MM Part 3 |
|---|---|---|---|
| - | - | - | - |
Examples
SELECT ST_Point_Inside_Circle(ST_GeomFromText('POINT(6 2)'), 3, 2, 2);
st_point_inside_circle
------------------------
f
(1 row)
SELECT ST_Point_Inside_Circle(ST_Point(3,1), 3, 2, 2);
st_point_inside_circle
------------------------
t
(1 row) |  |