I use PostgreSQL with POSTGIS extension.
I have a set of points in
the_geom column from a table myshema.myobjects
I would want create a select statement to get the centroid of this cluster, so from a select statement like this :
select the_geom from myshema.myobjects
Then I search the correct syntax of a statement that could look like that :
SELECT ST_AsText(ST_Centroid( (SELECT the_geom FROM myshema.myobjects) ));