First I would like to mention that I am not an expert with PostGreSQL so my question may seem dumb, but here it goes:
I have a database with over 800 000 points associated to a geometry (EPSG 2950) and I would like to cluster those in convex hulls based on this:
"Group every point that has (at least) 3 other points at a distance of maximum 100 meters."
The resulting laye would show polygons delimiting points that respect that condition.
I am guessing I would use the ST_ConvexHull fonction for this particular request but I am struggeling to see how i add my constraints.