I have a table x like this:
SubjectID int(11) Timestamp bigint(20) fix_geom point
When i try to group my fix_geom column to a MultiPoint (or GeometryCollection) by SubjectID, like:
SELECT SubjectID, ST_AsText(MultiPoint(fix_geom)) FROM x WHERE SubjectID = 100 GROUP BY SubjectID;
i get a table with a multipoint geometry, but it contains just one single Point instead of the many i'd liked to see there...:
Can anybody tell me what i'm doing wrong?
Cheers and many thanks in advance, Olaf