Name

ST_Point_Inside_Circle — Is the point geometry insert circle defined by center_x, center_y , radius

Synopsis

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

Description

The syntax for this functions is point_inside_circle(<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

Examples

SELECT ST_Point_Inside_Circle(ST_Point(1,2), 0.5, 2, 3);
 st_point_inside_circle
------------------------
 t

See Also

ST_DWithin