Fw: [postgis-users] about point and multipoint

[fsalas]

Thanks, Kevin
Now being working very good
Best Regards,Salas


----- Original Message ----- 
From: "Kevin Neufeld" <kneufeld at refractions.net>
To: "fsalas" <fsalas at geocuba.cu>; "PostGIS Users Discussion" 
<postgis-users at postgis.refractions.net>
Sent: Wednesday, August 27, 2008 1:09 PM
Subject: Re: [postgis-users] about point and multipoint


> ST_X() and ST_Y() expect the input to be a point, not a multipoint.
> You'll need to explode your collection into a list of points.
>
> Try this:
>
> SELECT ST_X(geom), ST_Y(geom)
> FROM
>   (SELECT (ST_Dump(geoloc)).geom
>    FROM consultorios) AS foo;
>
> -- Kevin
>
>
>
> fsalas wrote:
>> Hi,
>>
>>
>> How I can obtain the X,Y coordinates in one Multipoint table.
>>
>> When I try to execute this
>>
>> select ST_X(geoloc), ST_Y(geoloc) from consultorios
>>
>> PostgreeSql/Postgis show the error
>>
>> ERROR: Argument to X() must be a point
>>
>> ERROR: Argument to X() must be a point
>>
>>  Best Regards,Salas
>>
>>
>> ___________________________________
>> Dpto de Sistemas Informáticos
>> Oficina Central Grupo Empresarial GEOCUBA
>> Este mensaje esta libre de virus.
>> Revisado por Kaspersky Antivirus
>> ----------------------------------------------------------------------
>> Engine version: 4.0.1.14 Engine date: 2002/06/25 Definition count:
>> 1025598 Definition date: 2008/08/27 MDAV version: 2.2.9
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

___________________________________
Dpto de Sistemas Informáticos
Oficina Central Grupo Empresarial GEOCUBA
Este mensaje esta libre de virus. 
Revisado por Kaspersky Antivirus
----------------------------------------------------------------------
Engine version:  4.0.1.14
Engine date:  2002/06/25
Definition count:  1025598
Definition date:  2008/08/27
MDAV version: 2.2.9