I use PostgreSQL with the PostGIS extension.
I have a set of points in
the_geom column from a table
myschema.myobjects. I want to create a select statement to get the centroid of this cluster, so from a select statement like this:
SELECT the_geom FROM myschema.myobjects
I need to find the correct syntax for a statement like:
SELECT ST_AsText(ST_Centroid( (SELECT the_geom FROM myshema.myobjects) ));