Name

ST_PointInsideCircle — Is the point geometry inside the circle defined by center_x, center_y, radius

Synopsis

boolean ST_PointInsideCircle(geometry a_point, float center_x, float center_y, float radius);

Description

The syntax for this functions is ST_PointInsideCircle(<geometry>,<circle_center_x>,<circle_center_y>,<radius>). Returns the true if the geometry is a point and is inside the circle. Returns false otherwise.

[Note]

This only works for points as the name suggests

Availability: 1.2

Changed: 2.2.0 In prior versions this used to be called ST_Point_Inside_Circle

Examples

SELECT ST_PointInsideCircle(ST_Point(1,2), 0.5, 2, 3);
 st_pointinsidecircle
------------------------
 t

See Also

ST_DWithin