[postgis-users] about point and multipoint

[Kevin Neufeld]

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