You could use st_multi() to cast them al to multi point:
ST_Multi(geometry)
Returns the geometry as a MULTI* geometry. If the geometry is
already a MULTI*, it is returned unchanged.
SELECT ST_MULTI(wkb_geometry) FROM table;
On Mon, Sep 14, 2009 at 6:22 AM, <[email protected]> wrote:
> Hi,
> I have a postgistable with different geometrytyps in one table: points and
> multipoints (get this information via ST_GeometryType).
> UMN Mapserver have no problems to show the geometrys, but if I try to export
> this table via ogr2ogr there is an error:
> Attempt to write non-poin(MULTIPOINT) to point shapefile.
> How can I cast all my geometrys to point?
> Jo
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Richard Greenwood
[email protected]
www.greenwoodmap.com
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
