ST_PointInsideCircle — Is the point geometry inside the circle defined by center_x, center_y, radius
boolean ST_PointInsideCircle(geometry a_point, float center_x, float center_y, float radius
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.
This only works for points as the name suggests
Changed: 2.2.0 In prior versions this used to be called ST_Point_Inside_Circle
SELECT ST_PointInsideCircle(ST_Point(1,2), 0.5, 2, 3); st_pointinsidecircle ------------------------ t