[postgis-users] Center of Points Collection

[Dustin Butler]

Hello,

Trying to figure out how to find center using a collection of points.  For example something like this which doesn't work but you get the idea.

SELECT ST_AsText(ST_Centriod(SELECT point_geom FROM pb.pb_statistics WHERE pb_debit=1));

I think I need to make a multipoint geom out of the points and pass that but haven't figure out yet.

Thanks,
Dustin Butler
Intrcomm Technology

Skype: dustinbutler