[postgis-users] multipoint2point

[jj.wag at gmx.de]

thank you very much ST_MULTI works fine and solves my problem, is there a 
function to cast a MULTIPOINT to POINT?


----- Original Message ----- 
From: "Richard Greenwood" <richard.greenwood at gmail.com>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Tuesday, September 15, 2009 5:25 AM
Subject: Re: [postgis-users] multipoint2point


> 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,  <jj.wag at gmx.de> 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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
> -- 
> Richard Greenwood
> richard.greenwood at gmail.com
> www.greenwoodmap.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>